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