Pivot Tables

xlAllocationSpecifies when to calculate changes when performing what-if analysis on a PivotTable based on an OLAP data source.
xlAllocationMethodSpecifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlAllocationValueSpecifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source.
xlCalculatedMemberTypeSpecifies the type of a calculated member in a pivot table.
xlCellChangedStateSpecifies whether a pivottable value cell has been edited or recalculated since the pivottable report was created or the last commit operation was performed.
xlFileValidationPivotModeSpecifies how to validate the data caches for PivotTable reports.
xlLayoutFormTypeSpecifies the way the specified PivotTable items appear in table format or in outline format.
xlLocationInTableSpecifies the part of the PivotTable report that contains the upper-left corner of a range.
xlPivotCellTypeSpecifies the PivotTable entity the cell corresponds to.
xlPivotConditionScopeSpecifies the conditional formatting applied for filtering values from the PivotTable object.
xlPivotFieldCalculationSpecifies the type of calculation performed by a data PivotField when a custom calculation is used.
xlPivotFieldDataTypeSpecifies the type of data in the PivotTable field.
xlPivotFieldOrientationSpecifies the location of the field in a PivotTable report.
xlPivotFieldRepeatLabelsSpecifies whether to repeat all field item labels in a PivotTable report.
xlPivotFilterTypeSpecifies the type of filter applied.
xlPivotFormatTypeSpecifies the type of report formatting to be applied to the specified PivotTable report.
xlPivotLineTypeSpecifies the type of the PivotLine.
xlPivotTableMissingItemsSpecifies the maximum number of unique items per PivotField allowed.
xlPivotTableSourceTypeSpecifies the source of the report data.
xlPivotTableVersionListSpecifies the Excel version number.
xlPTSelectionModeSpecifies what may be selected in a pivottable during a structured selection.
xlQueryTypeSpecifies the type of query used to populate the query table or pivottable cache.
xlRobustConnectSpecifies 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.

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