My company use an Excel Dashboard reporting format, with one tab containing the source data for the pivots tables and charts.
The issue is that sometimes the source data in the tab is just too big for Excel to handle and impractically large to send to the clients.
My idea for a solution is the PowerPivot add in. This way the dashboard can read off of an external source: in our case an access database stored in Dropbox.
my questions are:
If I download the add-in, when i send the dashboard to the client will the add in be sent too? I.E I don't want the client to have the hassle of separately downloading it.
Is the add in any good? I.E when filtering your data, is it really as quick as it claims?
Is dropbox a good idea for cloud storage?
Thanks in advance!