PivotTable.AllocationValue (Excel)

Returns or sets the value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Possible return values are xlAllocateIncrement - Increment based on the old value, xlAllocateValue - The value entered divided by the number of allocations.

The AllocationValue property corresponds to the Value to Allocate setting in the What-If Analysis Settings dialog box. The default setting is xlAllocateValue, which corresponds to the setting The value entered divided by the number of allocations.


ActiveCell.PivotTable.AllocationValue = xlAllocateIncrement