Camilo Amarcy
New Member
Hi Chandoo's Friends,
I come again with a scenario:
1) I have a dashboard that everyday requires new information updated by the row data on a differente sheet.
2) Currently the dashboard file is the same for the row data file.
3) Every day I need to send the dashboard file to my manager, so he can play with the dashboard and see who the company is working.
Problems:
A) My manager what to share the same file with other managers, so now I need to send the file for more people.
B) As the days are passing, the file is growing because the row data is growing. So now I have a file with 5 MB (in January was with 2MB).
C) My email limitation only allow me to send up to 5 MB in the attachment (so soon I wount be able to share the file by email).
Non-Valid Solutions:
a) I cannot create hyperlinks on the Dashboard file to another file because is sensitive data and users must not be able to see the row file.
b) Some times the network of the company is not available and the links could be broken
My vision (just dont know how to apply):
- I would like to have the integration between excel and web interface.
/Camilo
I come again with a scenario:
1) I have a dashboard that everyday requires new information updated by the row data on a differente sheet.
2) Currently the dashboard file is the same for the row data file.
3) Every day I need to send the dashboard file to my manager, so he can play with the dashboard and see who the company is working.
Problems:
A) My manager what to share the same file with other managers, so now I need to send the file for more people.
B) As the days are passing, the file is growing because the row data is growing. So now I have a file with 5 MB (in January was with 2MB).
C) My email limitation only allow me to send up to 5 MB in the attachment (so soon I wount be able to share the file by email).
Non-Valid Solutions:
a) I cannot create hyperlinks on the Dashboard file to another file because is sensitive data and users must not be able to see the row file.
b) Some times the network of the company is not available and the links could be broken
My vision (just dont know how to apply):
- I would like to have the integration between excel and web interface.
/Camilo