XlAllocation Enumeration
Specifies when 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
Public Enumeration XlAllocation
'Usage
Dim instance As XlAllocation
public enum XlAllocation
Members
| Member name | Description | |
|---|---|---|
| xlManualAllocation | Calculate changes manually. | |
| xlAutomaticAllocation | Calculate changes automatically after each value is changed. |