In looping through a large pivot table and setting the visible property for
given items causes the pivot table report to recalculate each time something
is done, consuming time. How can I turn this off while looping and then make
it recalculate when finished?

I've tried setting
Application.Calculation=xlManual and
PivotTables(i).ManualUpdate=True

before starting the loop without success. any help appreciated.

ojv