Phoenix - Your AI AssistantExcel Dashboard
- Posted:
- Proposals: 25
- Remote
- #2954905
- Awarded
Mumbai 
Description
Experience Level: Expert
I have prepared one excel order book with drop down selections and created one dashboard with pivot table connected to the order book. Know i am facing below challenges and need assistance.
1. To lock the cells in excel so that no one can delete any section/only edit.
2. Once i fill the order form, the dashboard connected to pivot table doesn't update automatically. I have to go to analyse tab and refresh to update charts.
3. MOST IMPORTANT- As i have to place this excel on drop box or online excel tool wherein my partner can add orders and i can see. but whenever i upload on drop box or online Microsoft excel tool it gives error that the file contain many chart/images etc.
4. Also to add some more interactive charts on pivot table already prepared.
1. To lock the cells in excel so that no one can delete any section/only edit.
2. Once i fill the order form, the dashboard connected to pivot table doesn't update automatically. I have to go to analyse tab and refresh to update charts.
3. MOST IMPORTANT- As i have to place this excel on drop box or online excel tool wherein my partner can add orders and i can see. but whenever i upload on drop box or online Microsoft excel tool it gives error that the file contain many chart/images etc.
4. Also to add some more interactive charts on pivot table already prepared.
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
explain more pleas?