Export (0) Print
Expand All
Expand Minimize

XlAllocation Enumeration

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

Version Added: Excel 2010

Name

Value

Description

xlAutomaticAllocation

2

Calculate changes automatically after each value is changed.

xlManualAllocation

1

Calculate changes manually.

Show:
© 2014 Microsoft