PivotTable.Allocation Property
Gets 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.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Property Allocation As XlAllocation
Get
Set
'Usage
Dim instance As PivotTable
Dim value As XlAllocation
value = instance.Allocation
instance.Allocation = value
XlAllocation Allocation { get; set; }
Property Value
Type: Microsoft.Office.Interop.Excel.XlAllocation
An XlAllocation object.
Remarks
Read/write.
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.