Syntax

expression.ManualUpdate

expression A variable that represents a PivotTable object.

Remarks

This property is set to False immediately after your program terminates and after you execute the statement in the Immediate window of the Microsoft Visual Basic Editor.

Example

This example causes the PivotTable report to be recalculated only at the user's request.

Visual Basic for Applications 
Worksheets(1).PivotTables("Pivot1").ManualUpdate = True
manual manual update Manual Update Property ManualUpdate manualupdate property return manual update setting set pivot table recalculated manually set pivot table to be recalculated only at user's request

See also: