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