XlAllocationMethod Enumeration

Specifies the method to use to allocate values 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 XlAllocationMethod
'Usage
Dim instance As XlAllocationMethod
public enum XlAllocationMethod

Members

Member name Description
xlEqualAllocation Use equal allocation.
xlWeightedAllocation Use weighted allocation.

See Also

Reference

Microsoft.Office.Interop.Excel Namespace