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. |