XlAllocationMethod enumeration

Office 2013 and later

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)

C#
VB
C++
Copy
No code example is currently available or this language may not be supported.

Member nameDescription
xlEqualAllocationUse equal allocation.
xlWeightedAllocationUse weighted allocation.
Show: