xlAllocation

Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.

xlAutomaticAllocationCalculate changes automatically after each value is changed (2)
xlManualAllocationCalculate changes manually (1)

xlAutomaticAllocation
Calculate changes automatically after each value is changed (2)
xlManualAllocation
Calculate changes manually (1)

REMARKS
* Added in 2010.

© 2021 Better Solutions Limited. All Rights Reserved. © 2021 Better Solutions Limited Top