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. |
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. |
xlAllocationMethod |
| Specifies the method to use to allocate values when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlEqualAllocation | Use equal allocation (1) |
| xlWeightedAllocation | Use weighted allocation (2) |
| xlEqualAllocation |
| Use equal allocation (1) |
| xlWeightedAllocation |
| Use weighted allocation (2) |
| REMARKS |
| * Added in 2010. |
xlAllocationValue |
| Specifies what value to allocate when performing what-if analysis on a PivotTable report based on an OLAP data source. |
| xlAllocateIncrement | Increment based on the old value (2) |
| xlAllocateValue | The value entered divided by the number of allocations (1) |
| xlAllocateIncrement |
| Increment based on the old value (2) |
| xlAllocateValue |
| The value entered divided by the number of allocations (1) |
| REMARKS |
| * Added in 2010. |
xlCalculatedMemberType |
| Specifies the type of a calculated member in a pivot table. |
| xlCalculatedMeasure | (Added in ??) The member is a Multidimensional Expression (MDX) that defines the measure (2) |
| xlCalculatedMember | (Added in 2013) The member uses a Multidimensional Expression (MDX) formula (0) |
| xlCalculatedSet | The member contains an MDX formula for a set in a cube field (1) |
| xlCalculatedMeasure |
| (Added in ??) The member is a Multidimensional Expression (MDX) that defines the measure (2) |
| xlCalculatedMember |
| (Added in 2013) The member uses a Multidimensional Expression (MDX) formula (0) |
| xlCalculatedSet |
| The member contains an MDX formula for a set in a cube field (1) |
| REMARKS |
| * Added in 2002. |
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. |
| xlCellChangeApplied | The value in the cell has been edited or recalculated, and that change has been applied to the data source (Applies only PivotTable reports with OLAP data sources) (3) |
| xlCellChanged | The value in the cell has been edited or recalculated (2) |
| xlCellNotChanged | The value in the cell has not been edited or recalculated (1) |
| xlCellChangeApplied |
| The value in the cell has been edited or recalculated, and that change has been applied to the data source (Applies only PivotTable reports with OLAP data sources) (3) |
| xlCellChanged |
| The value in the cell has been edited or recalculated (2) |
| xlCellNotChanged |
| The value in the cell has not been edited or recalculated (1) |
| REMARKS |
| * Added in 2010. |
xlFileValidationPivotMode |
| Specifies how to validate the data caches for PivotTable reports. |
| xlFileValidationPivotDefault | Validate the contents of data caches as specified by the PivotOptions registry setting (default) (0) |
| xlFileValidationPivotRun | Validate the contents of all data caches regardless of the registry setting (1) |
| xlFileValidationPivotSkip | Do not validate the contents of data caches (2) |
| xlFileValidationPivotDefault |
| Validate the contents of data caches as specified by the PivotOptions registry setting (default) (0) |
| xlFileValidationPivotRun |
| Validate the contents of all data caches regardless of the registry setting (1) |
| xlFileValidationPivotSkip |
| Do not validate the contents of data caches (2) |
| REMARKS |
| * Added in 2010. * This enumeration is used to specify the setting of the FileValidationPivot property of the Application object. * The effect of the xlFileValidationPivotDefault setting is controlled by the PivotOptions registry value, which is set in the following registry subkey: HKEY_CURRENT_USER\Software\Microsoft\Office\14.0\Excel\Security\FileValidation. The PivotOptions value is a DWORD value that can be set as listed in the following table. * xlXMLData (47) this was listed in the MSFT website but is not in the 2003 enumeration ?? |
xlLayoutFormType |
| Specifies the way the specified PivotTable items appear in table format or in outline format. |
| xlOutline | Outline (1) |
| xlTabular | Tabular (0) |
| xlOutline |
| Outline (1) |
| xlTabular |
| Tabular (0) |
| REMARKS |
| * Added in 2000. |
xlLocationInTable |
| Specifies the part of the PivotTable report that contains the upper-left corner of a range. |
| xlColumnHeader | Column Header (-4110) |
| xlColumnItem | Column Item (5) |
| xlDataHeader | Data Header (3) |
| xlDataItem | Data Item (7) |
| xlPageHeader | Page Header (2) |
| xlPageItem | Page Item (6) |
| xlRowHeader | Row Header (-4153) |
| xlRowItem | Row Item (4) |
| xlTableBody | Table Body (8) |
| xlColumnHeader |
| Column Header (-4110) |
| xlColumnItem |
| Column Item (5) |
| xlDataHeader |
| Data Header (3) |
| xlDataItem |
| Data Item (7) |
| xlPageHeader |
| Page Header (2) |
| xlPageItem |
| Page Item (6) |
| xlRowHeader |
| Row Header (-4153) |
| xlRowItem |
| Row Item (4) |
| xlTableBody |
| Table Body (8) |
xlPivotCellType |
| Specifies the PivotTable entity the cell corresponds to. |
| xlPivotCellBlankCell | 9 |
| xlPivotCellCustomSubtotal | 7 |
| xlPivotCellDataField | 4 |
| xlPivotCellDataPivotField | 8 |
| xlPivotCellGrandTotal | 3 |
| xlPivotCellPageFieldItem | 6 |
| xlPivotCellPivotField | 5 |
| xlPivotCellPivotItem | 1 |
| xlPivotCellSubtotal | 2 |
| xlPivotCellValue | 0 |
| xlPivotCellBlankCell |
| 9 |
| xlPivotCellCustomSubtotal |
| 7 |
| xlPivotCellDataField |
| 4 |
| xlPivotCellDataPivotField |
| 8 |
| xlPivotCellGrandTotal |
| 3 |
| xlPivotCellPageFieldItem |
| 6 |
| xlPivotCellPivotField |
| 5 |
| xlPivotCellPivotItem |
| 1 |
| xlPivotCellSubtotal |
| 2 |
| xlPivotCellValue |
| 0 |
| REMARKS |
| * Added in 2002. |
xlPivotConditionScope |
| Specifies the conditional formatting applied for filtering values from the PivotTable object. |
| xlDataFieldScope | Based on the data in the specified fields (2) |
| xlFieldsScope | Based on the specified fields (1) |
| xlSelectionScope | Based on the specified selection criteria (0) |
| xlDataFieldScope |
| Based on the data in the specified fields (2) |
| xlFieldsScope |
| Based on the specified fields (1) |
| xlSelectionScope |
| Based on the specified selection criteria (0) |
| REMARKS |
| * Added in 2007. |
xlPivotFieldCalculation |
| Specifies the type of calculation performed by a data PivotField when a custom calculation is used. |
| xlDifferenceFrom | 2 |
| xlIndex | 9 |
| xlNoAdditionalCalculation | -4143 |
| xlPercentDifferenceFrom | 4 |
| xlPercentOf | 3 |
| xlPercentOfColumn | 7 |
| xlPercentOfParent | (Added in 2010) |
| xlPercentOfParentColumn | (Added in 2010) |
| xlPercentOfParentRow | (Added in 2010) |
| xlPercentOfRow | 6 |
| xlPercentOfTotal | 8 |
| xlPercentRunningTotal | (Added in 2010) |
| xlRankAscending | (Added in 2010) |
| xlRankDescending | (Added in 2010) |
| xlRunningTotal | 5 |
| xlDifferenceFrom |
| 2 |
| xlIndex |
| 9 |
| xlNoAdditionalCalculation |
| -4143 |
| xlPercentDifferenceFrom |
| 4 |
| xlPercentOf |
| 3 |
| xlPercentOfColumn |
| 7 |
| xlPercentOfParent |
| (Added in 2010) |
| xlPercentOfParentColumn |
| (Added in 2010) |
| xlPercentOfParentRow |
| (Added in 2010) |
| xlPercentOfRow |
| 6 |
| xlPercentOfTotal |
| 8 |
| xlPercentRunningTotal |
| (Added in 2010) |
| xlRankAscending |
| (Added in 2010) |
| xlRankDescending |
| (Added in 2010) |
| xlRunningTotal |
| 5 |
xlPivotFieldDataType |
| Specifies the type of data in the PivotTable field. |
| xlDate | 2 |
| xlNumber | -4145 |
| xlText | -4158 |
| xlDate |
| 2 |
| xlNumber |
| -4145 |
| xlText |
| -4158 |
xlPivotFieldOrientation |
| Specifies the location of the field in a PivotTable report. |
| xlColumnField | 2 |
| xlDataField | 4 |
| xlHidden | 0 |
| xlPageField | 3 |
| xlRowField | 1 |
| xlColumnField |
| 2 |
| xlDataField |
| 4 |
| xlHidden |
| 0 |
| xlPageField |
| 3 |
| xlRowField |
| 1 |
xlPivotFieldRepeatLabels |
| Specifies whether to repeat all field item labels in a PivotTable report. |
| xlDoNotRepeatLabels | Do not repeat item labels (1) |
| xlRepeatLabels | Repeat all item labels (2) |
| xlDoNotRepeatLabels |
| Do not repeat item labels (1) |
| xlRepeatLabels |
| Repeat all item labels (2) |
| REMARKS |
| * Added in 2010. |
xlPivotFilterType |
| Specifies the type of filter applied. |
| xlBefore | Filters for all dates before a specified date (31) |
| xlBeforeOrEqualTo | Filters for all dates on or before a specified date (32) |
| xlAfter | Filters for all dates after a specified date (33) |
| xlAfterOrEqualTo | Filters for all dates on or after a specified date (34) |
| xlAllDatesInPeriodJanuary | Filters for all dates in January (53) |
| xlAllDatesInPeriodFebruary | Filters for all dates in February (54) |
| xlAllDatesInPeriodMarch | Filters for all dates in March (55) |
| xlAllDatesInPeriodApril | Filters for all dates in April (56) |
| xlAllDatesInPeriodMay | Filters for all dates in May (57) |
| xlAllDatesInPeriodJune | Filters for all dates in June (58) |
| xlAllDatesInPeriodJuly | Filters for all dates in July (59) |
| xlAllDatesInPeriodAugust | Filters for all dates in August (60) |
| xlAllDatesInPeriodSeptember | Filters for all dates in September (61) |
| xlAllDatesInPeriodOctober | Filters for all dates in October (62) |
| xlAllDatesInPeriodNovember | Filters for all dates in November (63) |
| xlAllDatesInPeriodDecember | Filters for all dates in December (64) |
| xlAllDatesInPeriodQuarter1 | Filters for all dates in Quarter1 (49) |
| xlAllDatesInPeriodQuarter2 | Filters for all dates in Quarter2 (50) |
| xlAllDatesInPeriodQuarter3 | Filters for all dates in Quarter3 (51) |
| xlAllDatesInPeriodQuarter4 | Filters for all dates in Quarter 4 (52) |
| xlBottomCount | Filters for the specified number of values from the bottom of a list (2) |
| xlBottomPercent | Filters for the specified percentage of values from the bottom of a list (4) |
| xlBottomSum | Sum of the values from the bottom of the list (6) |
| xlCaptionBeginsWith | Filters for all captions beginning with the specified string (17) |
| xlCaptionContains | Filters for all captions that contain the specified string (21) |
| xlCaptionDoesNotBeginWith | Filters for all captions that do not begin with the specified string (18) |
| xlCaptionDoesNotContain | Filters for all captions that do not contain the specified string (22) |
| xlCaptionDoesNotEndWith | Filters for all captions that do not end with the specified string (20) |
| xlCaptionDoesNotEqual | Filters for all captions that do not match the specified string (16) |
| xlCaptionEndsWith | Filters for all captions that end with the specified string (19) |
| xlCaptionEquals | Filters for all captions that match the specified string (15) |
| xlCaptionIsBetween | Filters for all captions that are between a specified range of values (27) |
| xlCaptionIsGreaterThan | Filters for all captions that are greater than the specified value (23) |
| xlCaptionIsGreaterThanOrEqualTo | Filters for all captions that are greater than or match the specified value (24) |
| xlCaptionIsLessThan | Filters for all captions that are less than the specified value (25) |
| xlCaptionIsLessThanOrEqualTo | Filters for all captions that are less than or match the specified value (26) |
| xlCaptionIsNotBetween | Filters for all captions that are not between a specified range of values (28) |
| xlDateBetween | Filters for all dates that are between a specified range of dates (32) |
| xlDateLastMonth | Filters for all dates that apply to the previous month (41) |
| xlDateLastQuarter | Filters for all dates that apply to the previous quarter (44) |
| xlDateLastWeek | Filters for all dates that apply to the previous week (38) |
| xlDateLastYear | Filters for all dates that apply to the previous year (47) |
| xlDateNextMonth | Filters for all dates that apply to the next month (39) |
| xlDateNextQuarter | Filters for all dates that apply to the next quarter (42) |
| xlDateNextWeek | Filters for all dates that apply to the next week (36) |
| xlDateNextYear | Filters for all dates that apply to the next year (45) |
| xlDateThisMonth | Filters for all dates that apply to the current month (40) |
| xlDateThisQuarter | Filters for all dates that apply to the current quarter (43) |
| xlDateThisWeek | Filters for all dates that apply to the current week (37) |
| xlDateThisYear | Filters for all dates that apply to the current year (46) |
| xlDateToday | Filters for all dates that apply to the current date (34) |
| xlDateTomorrow | Filters for all dates that apply to the next day (33) |
| xlDateYesterday | Filters for all dates that apply to the previous day (35) |
| xlNotSpecificDate | Filters for all dates that do not match a specified date (30) |
| xlSpecificDate | Filters for all dates that match a specified date (29) |
| xlTopCount | Filters for the specified number of values from the top of a list (1) |
| xlTopPercent | Filters for the specified percentage of values from a list (3) |
| xlTopSum | Sum of the values from the top of the list (5) |
| xlValueDoesNotEqual | Filters for all values that do not match the specified value (8) |
| xlValueEquals | Filters for all values that match the specified value (7) |
| xlValueIsBetween | Filters for all values that are between a specified range of values (13) |
| xlValueIsGreaterThan | Filters for all values that are greater than the specified value (9) |
| xlValueIsGreaterThanOrEqualTo | Filters for all values that are greater than or match the specified value (10) |
| xlValueIsLessThan | Filters for all values that are less than the specified value (11) |
| xlValueIsLessThanOrEqualTo | Filters for all values that are less than or match the specified value (12) |
| xlValueIsNotBetween | Filters for all values that are not between a specified range of values (14) |
| xlYearToDate | Filters for all values that are within one year of a specified date (48) |
| xlBefore |
| Filters for all dates before a specified date (31) |
| xlBeforeOrEqualTo |
| Filters for all dates on or before a specified date (32) |
| xlAfter |
| Filters for all dates after a specified date (33) |
| xlAfterOrEqualTo |
| Filters for all dates on or after a specified date (34) |
| xlAllDatesInPeriodJanuary |
| Filters for all dates in January (53) |
| xlAllDatesInPeriodFebruary |
| Filters for all dates in February (54) |
| xlAllDatesInPeriodMarch |
| Filters for all dates in March (55) |
| xlAllDatesInPeriodApril |
| Filters for all dates in April (56) |
| xlAllDatesInPeriodMay |
| Filters for all dates in May (57) |
| xlAllDatesInPeriodJune |
| Filters for all dates in June (58) |
| xlAllDatesInPeriodJuly |
| Filters for all dates in July (59) |
| xlAllDatesInPeriodAugust |
| Filters for all dates in August (60) |
| xlAllDatesInPeriodSeptember |
| Filters for all dates in September (61) |
| xlAllDatesInPeriodOctober |
| Filters for all dates in October (62) |
| xlAllDatesInPeriodNovember |
| Filters for all dates in November (63) |
| xlAllDatesInPeriodDecember |
| Filters for all dates in December (64) |
| xlAllDatesInPeriodQuarter1 |
| Filters for all dates in Quarter1 (49) |
| xlAllDatesInPeriodQuarter2 |
| Filters for all dates in Quarter2 (50) |
| xlAllDatesInPeriodQuarter3 |
| Filters for all dates in Quarter3 (51) |
| xlAllDatesInPeriodQuarter4 |
| Filters for all dates in Quarter 4 (52) |
| xlBottomCount |
| Filters for the specified number of values from the bottom of a list (2) |
| xlBottomPercent |
| Filters for the specified percentage of values from the bottom of a list (4) |
| xlBottomSum |
| Sum of the values from the bottom of the list (6) |
| xlCaptionBeginsWith |
| Filters for all captions beginning with the specified string (17) |
| xlCaptionContains |
| Filters for all captions that contain the specified string (21) |
| xlCaptionDoesNotBeginWith |
| Filters for all captions that do not begin with the specified string (18) |
| xlCaptionDoesNotContain |
| Filters for all captions that do not contain the specified string (22) |
| xlCaptionDoesNotEndWith |
| Filters for all captions that do not end with the specified string (20) |
| xlCaptionDoesNotEqual |
| Filters for all captions that do not match the specified string (16) |
| xlCaptionEndsWith |
| Filters for all captions that end with the specified string (19) |
| xlCaptionEquals |
| Filters for all captions that match the specified string (15) |
| xlCaptionIsBetween |
| Filters for all captions that are between a specified range of values (27) |
| xlCaptionIsGreaterThan |
| Filters for all captions that are greater than the specified value (23) |
| xlCaptionIsGreaterThanOrEqualTo |
| Filters for all captions that are greater than or match the specified value (24) |
| xlCaptionIsLessThan |
| Filters for all captions that are less than the specified value (25) |
| xlCaptionIsLessThanOrEqualTo |
| Filters for all captions that are less than or match the specified value (26) |
| xlCaptionIsNotBetween |
| Filters for all captions that are not between a specified range of values (28) |
| xlDateBetween |
| Filters for all dates that are between a specified range of dates (32) |
| xlDateLastMonth |
| Filters for all dates that apply to the previous month (41) |
| xlDateLastQuarter |
| Filters for all dates that apply to the previous quarter (44) |
| xlDateLastWeek |
| Filters for all dates that apply to the previous week (38) |
| xlDateLastYear |
| Filters for all dates that apply to the previous year (47) |
| xlDateNextMonth |
| Filters for all dates that apply to the next month (39) |
| xlDateNextQuarter |
| Filters for all dates that apply to the next quarter (42) |
| xlDateNextWeek |
| Filters for all dates that apply to the next week (36) |
| xlDateNextYear |
| Filters for all dates that apply to the next year (45) |
| xlDateThisMonth |
| Filters for all dates that apply to the current month (40) |
| xlDateThisQuarter |
| Filters for all dates that apply to the current quarter (43) |
| xlDateThisWeek |
| Filters for all dates that apply to the current week (37) |
| xlDateThisYear |
| Filters for all dates that apply to the current year (46) |
| xlDateToday |
| Filters for all dates that apply to the current date (34) |
| xlDateTomorrow |
| Filters for all dates that apply to the next day (33) |
| xlDateYesterday |
| Filters for all dates that apply to the previous day (35) |
| xlNotSpecificDate |
| Filters for all dates that do not match a specified date (30) |
| xlSpecificDate |
| Filters for all dates that match a specified date (29) |
| xlTopCount |
| Filters for the specified number of values from the top of a list (1) |
| xlTopPercent |
| Filters for the specified percentage of values from a list (3) |
| xlTopSum |
| Sum of the values from the top of the list (5) |
| xlValueDoesNotEqual |
| Filters for all values that do not match the specified value (8) |
| xlValueEquals |
| Filters for all values that match the specified value (7) |
| xlValueIsBetween |
| Filters for all values that are between a specified range of values (13) |
| xlValueIsGreaterThan |
| Filters for all values that are greater than the specified value (9) |
| xlValueIsGreaterThanOrEqualTo |
| Filters for all values that are greater than or match the specified value (10) |
| xlValueIsLessThan |
| Filters for all values that are less than the specified value (11) |
| xlValueIsLessThanOrEqualTo |
| Filters for all values that are less than or match the specified value (12) |
| xlValueIsNotBetween |
| Filters for all values that are not between a specified range of values (14) |
| xlYearToDate |
| Filters for all values that are within one year of a specified date (48) |
| REMARKS |
| * Added in 2007. |
xlPivotFormatType |
| Specifies the type of report formatting to be applied to the specified PivotTable report. |
| xlPTClassic | 20 |
| xlPTNone | 21 |
| xlReport1 | 0 |
| xlReport10 | 9 |
| xlReport2 | 1 |
| xlReport3 | 2 |
| xlReport4 | 3 |
| xlReport5 | 4 |
| xlReport6 | 5 |
| xlReport7 | 6 |
| xlReport8 | 7 |
| xlReport9 | 8 |
| xlTable1 | 10 |
| xlTable10 | 19 |
| xlTable2 | 11 |
| xlTable3 | 12 |
| xlTable4 | 13 |
| xlTable5 | 14 |
| xlTable6 | 15 |
| xlTable7 | 16 |
| xlTable8 | 17 |
| xlTable9 | 18 |
| xlPTClassic |
| 20 |
| xlPTNone |
| 21 |
| xlReport1 |
| 0 |
| xlReport10 |
| 9 |
| xlReport2 |
| 1 |
| xlReport3 |
| 2 |
| xlReport4 |
| 3 |
| xlReport5 |
| 4 |
| xlReport6 |
| 5 |
| xlReport7 |
| 6 |
| xlReport8 |
| 7 |
| xlReport9 |
| 8 |
| xlTable1 |
| 10 |
| xlTable10 |
| 19 |
| xlTable2 |
| 11 |
| xlTable3 |
| 12 |
| xlTable4 |
| 13 |
| xlTable5 |
| 14 |
| xlTable6 |
| 15 |
| xlTable7 |
| 16 |
| xlTable8 |
| 17 |
| xlTable9 |
| 18 |
| REMARKS |
| * Added in 2000. |
xlPivotLineType |
| Specifies the type of the PivotLine. |
| xlPivotLineBlank | Blank line after each group (3) |
| xlPivotLineGrandTotal | Grand Total line (2) |
| xlPivotLineRegular | Regular PivotLine with pivot items (0) |
| xlPivotLineSubtotal | Subtotal line (1) |
| xlPivotLineBlank |
| Blank line after each group (3) |
| xlPivotLineGrandTotal |
| Grand Total line (2) |
| xlPivotLineRegular |
| Regular PivotLine with pivot items (0) |
| xlPivotLineSubtotal |
| Subtotal line (1) |
| REMARKS |
| * Added in 2007. |
xlPivotTableMissingItems |
| Specifies the maximum number of unique items per PivotField allowed. |
| xlMissingItemsDefault | -1 |
| xlMissingItemsMax | 32500 |
| xlMissingItemsMax2 | (Added in 2007) |
| xlMissingItemsNone | 0 |
| xlMissingItemsDefault |
| -1 |
| xlMissingItemsMax |
| 32500 |
| xlMissingItemsMax2 |
| (Added in 2007) |
| xlMissingItemsNone |
| 0 |
| REMARKS |
| * Added in 2002. |
xlPivotTableSourceType |
| Specifies the source of the report data. |
| xlConsolidation | 3 |
| xlDatabase | 1 |
| xlExternal | 2 |
| xlPivotTable | -4148 |
| xlScenario | 4 |
| xlConsolidation |
| 3 |
| xlDatabase |
| 1 |
| xlExternal |
| 2 |
| xlPivotTable |
| -4148 |
| xlScenario |
| 4 |
xlPivotTableVersionList |
| Specifies the Excel version number. |
| xlPivotTableVersion10 | 1 |
| xlPivotTableVersion11 | (Added in 2007) |
| xlPivotTableVersion12 | (Added in 2007) |
| xlPivotTableVersion14 | (Added in 2010) |
| xlPivotTableVersion15 | (Added in 2013) |
| xlPivotTableVersion2000 | 0 |
| xlPivotTableVersionCurrent | -1 |
| xlPivotTableVersion10 |
| 1 |
| xlPivotTableVersion11 |
| (Added in 2007) |
| xlPivotTableVersion12 |
| (Added in 2007) |
| xlPivotTableVersion14 |
| (Added in 2010) |
| xlPivotTableVersion15 |
| (Added in 2013) |
| xlPivotTableVersion2000 |
| 0 |
| xlPivotTableVersionCurrent |
| -1 |
| REMARKS |
| * Added in 2002. |
xlPTSelectionMode |
| Specifies what may be selected in a pivottable during a structured selection. |
| xlBlanks | 4 |
| xlButton | 15 |
| xlDataAndLabel | 0 |
| xlDataOnly | 2 |
| xlFirstRow | 256 |
| xlLabelOnly | 1 |
| xlOrigin | 3 |
| xlBlanks |
| 4 |
| xlButton |
| 15 |
| xlDataAndLabel |
| 0 |
| xlDataOnly |
| 2 |
| xlFirstRow |
| 256 |
| xlLabelOnly |
| 1 |
| xlOrigin |
| 3 |
xlQueryType |
| Specifies the type of query used to populate the query table or pivottable cache. |
| xlADORecordset | Based on an ADO recordset query (7) |
| xlDAORecordset | Based on a DAO recordset query, for query tables only (2) |
| xlODBCQuery | Based on an ODBC data source (1) |
| xlOLEDBQuery | Based on an OLE DB query, including OLAP data sources (5) |
| xlTextImport | Based on a text file, for query tables only (6) |
| xlWebQuery | Based on a Web page, for query tables only (4) |
| xlADORecordset |
| Based on an ADO recordset query (7) |
| xlDAORecordset |
| Based on a DAO recordset query, for query tables only (2) |
| xlODBCQuery |
| Based on an ODBC data source (1) |
| xlOLEDBQuery |
| Based on an OLE DB query, including OLAP data sources (5) |
| xlTextImport |
| Based on a text file, for query tables only (6) |
| xlWebQuery |
| Based on a Web page, for query tables only (4) |
| REMARKS |
| * Added in 2000. |
xlRobustConnect |
| Specifies how the PivotTable cache connects to its data source. |
| xlAlways | 1 |
| xlAsRequired | 0 |
| xlNever | 2 |
| xlAlways |
| 1 |
| xlAsRequired |
| 0 |
| xlNever |
| 2 |
| REMARKS |
| * Added in 2002. |
© 2026 Better Solutions Limited. All Rights Reserved. © 2026 Better Solutions Limited Top