| title | keywords | f1_keywords | api_name | ms.assetid | ms.date | ms.localizationpriority | ||
|---|---|---|---|---|---|---|---|---|
PivotTable.Allocation property (Excel) |
vbaxl10.chm235187 |
|
|
ac7bd537-97f0-f643-3e34-dd13e49ac149 |
05/08/2019 |
medium |
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. Read/write.
expression.Allocation
expression A variable that represents a PivotTable object.
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.
[!includeSupport and feedback]