XlAllocationValue enumeration (Excel)
Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
| Name | Value | Description |
|---|---|---|
| xlAllocateIncrement | 2 | Increment based on the old value. |
| xlAllocateValue | 1 | The value entered divided by the number of allocations. |
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.