XlAllocationValue enumeration

Office 2013 and later

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)

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

Member nameDescription
xlAllocateValueThe value entered divided by the number of allocations.
xlAllocateIncrementIncrement based on the old value.
Show: