| title | api_name | ms.assetid | ms.date | ms.localizationpriority | |
|---|---|---|---|---|---|
XlAllocationValue enumeration (Excel) |
|
d7f73242-4adf-f700-a115-29c10d3a028a |
06/08/2017 |
medium |
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. |
[!includeSupport and feedback]