A
autogenix
Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel Dear forum,
I created 16 pivot table is one common spreadsheet. Depending on new entered data into the source table for these pivots I'd like to refresh all pivots in my spreadsheet just by clicking on one button.
Which setting or command (button) has to be entered?
Or,
do I really have to refresh each single pivot?
BTW: It works when I close and reopen the file (all reports refresh) but I cannot imagine this would be an appropriate solution...
I created 16 pivot table is one common spreadsheet. Depending on new entered data into the source table for these pivots I'd like to refresh all pivots in my spreadsheet just by clicking on one button.
Which setting or command (button) has to be entered?
Or,
do I really have to refresh each single pivot?
BTW: It works when I close and reopen the file (all reports refresh) but I cannot imagine this would be an appropriate solution...