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 Added: Excel 2010

expression .Allocation

expression A variable that represents a PivotTable object.

Return Value

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.

Show: