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