I don't know of any way to hide/show pivot all items without looping.
Make sure you have manual update turned on, e.g.:
ActiveSheet.PivotTables(1).ManualUpdate = True
Rupster wrote:
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
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html