PivotTable.Allocation (Excel)

Returns or sets whether to run an UPDATE CUBE statement for each cell that is edited, or only when the user chooses to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.

xlAutomaticAllocation - Calculate changes automatically after each value is changed, xlManualAllocation - Calculate changes manually.

The Allocation property corresponds to the Calculate with changes setting in the What-If Analysis Settings dialog box. The default setting is xlManualAllocation, which corresponds to the Manually (when selecting calculate PivotTable with changes) setting.

ActiveCell.PivotTable.Allocation = xlAutomaticAllocation
PivotTable.Allocation procedure builder