Collapse the table of content
Expand the table of content
Expand Minimize
Important This document may not represent best practices for current development, links to downloads and other resources may no longer be valid. Current recommended version can be found here. ArchiveDisclaimer

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.

© 2015 Microsoft