Hi

I have a VERY LARGE pivot table. As I have to loop through one of the pivot
fields (month of year) to show data by quarters it can take a long time to
complete the query as the pivot table refreshes on every occasion it
hides/unhides a pivot item. Is there any way I can hide/unhide pivotitems
simulataneously without going through a loop.?
Thanks
Rupster