XlAllocationValue Enum

Definition

Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.

C#
public enum XlAllocationValue
Inheritance
XlAllocationValue

Fields

Name Value Description
xlAllocateValue 1

The value entered divided by the number of allocations.

xlAllocateIncrement 2

Increment based on the old value.

Applies to

Product Versions
Excel primary interop assembly Latest