XlAllocation Enumeration
TOC
Collapse the table of content
Expand the table of content

XlAllocation Enumeration (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

Name

Value

Description

xlAutomaticAllocation

2

Calculate changes automatically after each value is changed.

xlManualAllocation

1

Calculate changes manually.

Show:
© 2016 Microsoft