This documentation is archived and is not being maintained.

PivotTable.AllocationValue Property (Excel)

Returns or sets what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. Read/write

Version Added: Excel 2010

expression .AllocationValue

expression A variable that represents a PivotTable object.

Return Value

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 The value entered divided by the number of allocations setting.