Refresh multiple pivot tables in one spreadsheet

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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top