ManualUpdate Property

Applies To

PivotTable object.

Description

True if the PivotTable is recalculated only at the user's request. The default value is False. Read/write Boolean.

Example

This example causes the PivotTable to recalculate only at the user's request and before the workbook is saved.

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