ManualUpdate Property Example
This example causes the PivotTable report to be recalculated only at the user's request and before the workbook is saved.
With Worksheets(1).PivotTables("Pivot1") .ManualUpdate = True .UpdateBeforeSave = True End With