XlAllocationValue Enumeration
Specifies what value to allocate when performing what-if analysis on a PivotTable report 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 XlAllocationValue
'Usage
Dim instance As XlAllocationValue
public enum XlAllocationValue
Members
| Member name | Description | |
|---|---|---|
| xlAllocateValue | The value entered divided by the number of allocations. | |
| xlAllocateIncrement | Increment based on the old value. |