| xlAllocation | 
| Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source. | 
| xlAutomaticAllocation | Calculate changes automatically after each value is changed (2) | 
| xlManualAllocation | Calculate changes manually (1) | 
| xlAutomaticAllocation | 
| Calculate changes automatically after each value is changed (2) | 
| xlManualAllocation | 
| Calculate changes manually (1) | 
| REMARKS | 
| * Added in 2010. | 
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited Top