update all the pivots at the same time

[Guest]

I have about six worksheets. Each worksheet has about ten pivots. I change
the raw data each day. After I input new data, I have to refresh each pivot.
Is there any way I can refresh all the pivots at the same time. One way to
do is by making a macro but that increases the file size and slows down data
manipulation. Can someone tell me any other way do acheive the same or macro
is the only way. Thanks a lot

 

[aidan.heritage]

As far as I know, a macro would be the only way, though the file size
aspect shouldnt' be that critical - it would increase a bit, but not a
lot, so I don't know why the data manipulation is slower?

 

[Debra Dalgleish]

Use the RefreshAll method:

ActiveWorkbook.RefreshAll

Or, open the External Data toolbar, and click the Refresh All button.