Share via

XlAllocationValue Enumeration

  • Article

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

Version Information

Version Added: Excel 2010

Name

Value

Description

xlAllocateIncrement

2

Increment based on the old value.

xlAllocateValue

1

The value entered divided by the number of allocations.