PivotTable.Allocation Property (Excel)
Returns or sets whether to run an UPDATE CUBE statement for each cell 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. Read/write
Version Information
Version Added: Excel 2010
Syntax
expression .Allocation
expression A variable that represents a PivotTable object.
Return Value
Remarks
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.