Excel Pivot Table Automation

[Store300]

I have a macro which automates the hiding of 'page' elements in a pivot table. The trouble is that the pivot table recalculates after each element is hidden rather than waiting until all the selected elements are hidden, slowing the whole process down considerably.

Does anyone know of a way to switch the recalculation of pivot tables on and off at will?

 

[DarkSun]

Look at the help in Excel VBA for :

PivotTable ManualUpdate

This is the example it gives.


With Worksheets(1).PivotTables("Pivot1&quot
.ManualUpdate = True
.UpdateBeforeSave = True
End With


You should be able to do what you want.

 

[Store300]

DarkSun:

Thankyou for that, nice to know that my trawling through the help files for anything to do with 'Calculation' was entriely the wrong direction to take..