update all the pivots at the same time
 

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

update all the pivots at the same time
 

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?

Purnima Sharma wrote:
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

update all the pivots at the same time
 

Use the RefreshAll method:

ActiveWorkbook.RefreshAll

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


Purnima Sharma wrote:
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


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html