Pivot Tables

xlAllocation	Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
xlAllocationMethod	Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlAllocationValue	Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlCalculatedMemberType	Specifies the type of a calculated member in a pivot table.
xlCellChangedState	Specifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed.
xlFileValidationPivotMode	Specifies how to validate the data caches for PivotTable reports.
xlLayoutFormType	Specifies the way the specified PivotTable items appear in table format or in outline format.
xlLocationInTable	Specifies the part of the PivotTable report that contains the upper-left corner of a range.
xlPivotCellType	Specifies the PivotTable entity the cell corresponds to.
xlPivotConditionScope	Specifies the conditional formatting applied for filtering values from the PivotTable object.
xlPivotFieldCalculation	Specifies the type of calculation performed by a data PivotField when a custom calculation is used.
xlPivotFieldDataType	Specifies the type of data in the PivotTable field.
xlPivotFieldOrientation	Specifies the location of the field in a PivotTable report.
xlPivotFieldRepeatLabels	Specifies whether to repeat all field item labels in a PivotTable report.
xlPivotFilterType	Specifies the type of filter applied.
xlPivotFormatType	Specifies the type of report formatting to be applied to the specified PivotTable report.
xlPivotLineType	Specifies the type of the PivotLine.
xlPivotTableMissingItems	Specifies the maximum number of unique items per PivotField allowed.
xlPivotTableSourceType	Specifies the source of the report data.
xlPivotTableVersionList	Specifies the Excel version number.
xlPTSelectionMode	Specifies what may be selected in a pivottable during a structured selection.
xlQueryType	Specifies the type of query used to populate the query table or pivottable cache.
xlRobustConnect	Specifies how the PivotTable cache connects to its data source.

xlAllocation Specifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
xlAllocationMethod Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlAllocationValue Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlCalculatedMemberType Specifies the type of a calculated member in a pivot table.
xlCellChangedState Specifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed.
xlFileValidationPivotMode Specifies how to validate the data caches for PivotTable reports.
xlLayoutFormType Specifies the way the specified PivotTable items appear in table format or in outline format.
xlLocationInTable Specifies the part of the PivotTable report that contains the upper-left corner of a range.
xlPivotCellType Specifies the PivotTable entity the cell corresponds to.
xlPivotConditionScope Specifies the conditional formatting applied for filtering values from the PivotTable object.
xlPivotFieldCalculation Specifies the type of calculation performed by a data PivotField when a custom calculation is used.
xlPivotFieldDataType Specifies the type of data in the PivotTable field.
xlPivotFieldOrientation Specifies the location of the field in a PivotTable report.
xlPivotFieldRepeatLabels Specifies whether to repeat all field item labels in a PivotTable report.
xlPivotFilterType Specifies the type of filter applied.
xlPivotFormatType Specifies the type of report formatting to be applied to the specified PivotTable report.
xlPivotLineType Specifies the type of the PivotLine.
xlPivotTableMissingItems Specifies the maximum number of unique items per PivotField allowed.
xlPivotTableSourceType Specifies the source of the report data.
xlPivotTableVersionList Specifies the Excel version number.
xlPTSelectionMode Specifies what may be selected in a pivottable during a structured selection.
xlQueryType Specifies the type of query used to populate the query table or pivottable cache.
xlRobustConnect Specifies how the PivotTable cache connects to its data source.