Expand Minimize

XlAllocationValue Enumeration (Excel)

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

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.

Show:
© 2015 Microsoft