Enumerations
Added in 2021
| xlGradientStopPositionType | Specifies the type of gradient stop position. |
| xlSeriesColorGradientStyle | Specifies the colour gradient style for a series. |
| xlGradientStopPositionType Specifies the type of gradient stop position. |
| xlSeriesColorGradientStyle Specifies the colour gradient style for a series. |
Added in 2019
| xlCategorySortOrder | Specifies the sort order for the category. |
| xlFormulaVersion | Specifies how you want formulas replaced when using Range.Replace. |
| xlGeoMappingLevel | Specifies the geography mapping level for a series within a chart group. |
| xlGeoProjectionType | Specifies the geography projection type for a series within the chart group. |
| xlLinkedDataTypeState | Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| xlRegionLabelOptions | Specifies the region labelling behavior for a series within the chart group. |
| xlValueSortOrder | Specifies the sort order for the values. |
| xlCategorySortOrder Specifies the sort order for the category. |
| xlFormulaVersion Specifies how you want formulas replaced when using Range.Replace. |
| xlGeoMappingLevel Specifies the geography mapping level for a series within a chart group. |
| xlGeoProjectionType Specifies the geography projection type for a series within the chart group. |
| xlLinkedDataTypeState Specifies the state of cells that may contain Linked data types such as Stocks or Geography. |
| xlRegionLabelOptions Specifies the region labelling behavior for a series within the chart group. |
| xlValueSortOrder Specifies the sort order for the values. |
Added in 2016
| xlBinsType | Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlForecastAggregation | Specifies the type of aggregation to use for the forecast. |
| xlForecastChartType | Specifies the type of chart displayed for the forecast. |
| xlForecastDataCompletion | Specifies how data is completed for the forecast. |
| xlParentDataLabelOptions | Specifies the values passed to and returned from the Series.ParentDataLabelOption property. |
| xlPublishToDocsDisclosureScope | Specifies the disclosure type when publishing a workbook to a document. |
| xlPublishToPBINameConflictAction | Specifies the conflict action when publishing to Power BI. |
| xlPublishToPBIPublishType | Specifies the publishing type when publishing to Power BI. |
| xlBinsType Specifies the values passed to and returned from the ChartGroup.BinsType property. |
| xlForecastAggregation Specifies the type of aggregation to use for the forecast. |
| xlForecastChartType Specifies the type of chart displayed for the forecast. |
| xlForecastDataCompletion Specifies how data is completed for the forecast. |
| xlParentDataLabelOptions Specifies the values passed to and returned from the Series.ParentDataLabelOption property. |
| xlPublishToDocsDisclosureScope Specifies the disclosure type when publishing a workbook to a document. |
| xlPublishToPBINameConflictAction Specifies the conflict action when publishing to Power BI. |
| xlPublishToPBIPublishType Specifies the publishing type when publishing to Power BI. |
Added in 2013
| xlCalcMemNumberFormatType | Specifies the format of cell values that are based on the calculated member. |
| xlCategoryLabelLevel | Specifies the category labels for the category label levels. |
| xlFilterStatus | Specifies the status of the filter. |
| xlModelChangeSource | Specifies the source of the change to the data model. |
| xlQuickAnalysisMode | Specifies which top level button the callout user interface is displayed. |
| xlSeriesNameLevel | Specifies the series labels for the series label levels. |
| xlSlicerCacheType | Specifies the cache type to be used in the slicer. |
| xlTimelineLevel | Specifies the time line to be used in the slicer. |
| xlTimeMoving | Specifies the period of time moving. (Removed in 2016) |
| xlCalcMemNumberFormatType Specifies the format of cell values that are based on the calculated member. |
| xlCategoryLabelLevel Specifies the category labels for the category label levels. |
| xlFilterStatus Specifies the status of the filter. |
| xlModelChangeSource Specifies the source of the change to the data model. |
| xlQuickAnalysisMode Specifies which top level button the callout user interface is displayed. |
| xlSeriesNameLevel Specifies the series labels for the series label levels. |
| xlSlicerCacheType Specifies the cache type to be used in the slicer. |
| xlTimelineLevel Specifies the time line to be used in the slicer. |
| xlTimeMoving Specifies the period of time moving. (Removed in 2016) |
Added in 2010
| xlAllocation | Specifies when to calculate changes when performing what-if analysis on a Pivot Table based on an OLAP data source. |
| xlAllocationMethod | Specifies the method to use to allocate values when performing what-if analysis on a Pivot Table report based on an OLAP data source. |
| xlAllocationValue | Specifies what value to allocate when performing what-if analysis on a Pivot Table report based on an OLAP data source. |
| xlCellChangedState | Specifies whether a Pivot Table value cell has been edited or recalculated since the Pivot Table report was created or the last commit operation was performed. |
| xlDataBarAxisPosition | Specifies the axis position for a range of cells with conditional formatting as data bars. |
| xlDataBarFillType | Specifies how a data bar is filled with color. |
| xlDataBarBorderType | Specifies the border of a data bar. |
| xlDataBarNegativeColorType | Specifies whether to use the same border and fill color as postive data bars. |
| xlFileValidationPivotMode | Specifies how to validate the data caches for Pivot Table reports. |
| xlIcon | Specifies the icon for a criterion in an icon set conditional formatting rule. |
| xlOartHorizontalOverflow | Specifies the horizontal overflow setting for a text frame. |
| xlOartVerticalOverflow | Specifies the vertical overflow setting for a text frame. |
| xlPieSliceIndex | Specifies which position on the slice to return the coordinate of. |
| xlPieSliceLocation | Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlPivotFieldRepeatLabels | Specifies whether to repeat all field item labels in a Pivot Table report. |
| xlPortugueseReform | Specifies the mode for checking the spelling of Portuguese. |
| xlProtectedViewCloseReason | Specifies how the Protected View window was closed. |
| xlProtectedViewWindowState | Specifies the state of the Protected View window. |
| xlSlicerCrossFilterType | Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
| xlSlicerSort | Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions. |
| xlSpanishModes | Specifies the mode for checking the spelling of Spanish. |
| xlSparklineRowCol | Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
| xlSparkScale | Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
| xlSparkType | Specifies the type of sparkline. |
| xlAllocation Specifies when to calculate changes when performing what-if analysis on a Pivot Table based on an OLAP data source. |
| xlAllocationMethod Specifies the method to use to allocate values when performing what-if analysis on a Pivot Table report based on an OLAP data source. |
| xlAllocationValue Specifies what value to allocate when performing what-if analysis on a Pivot Table report based on an OLAP data source. |
| xlCellChangedState Specifies whether a Pivot Table value cell has been edited or recalculated since the Pivot Table report was created or the last commit operation was performed. |
| xlDataBarAxisPosition Specifies the axis position for a range of cells with conditional formatting as data bars. |
| xlDataBarFillType Specifies how a data bar is filled with color. |
| xlDataBarBorderType Specifies the border of a data bar. |
| xlDataBarNegativeColorType Specifies whether to use the same border and fill color as postive data bars. |
| xlFileValidationPivotMode Specifies how to validate the data caches for Pivot Table reports. |
| xlIcon Specifies the icon for a criterion in an icon set conditional formatting rule. |
| xlOartHorizontalOverflow Specifies the horizontal overflow setting for a text frame. |
| xlOartVerticalOverflow Specifies the vertical overflow setting for a text frame. |
| xlPieSliceIndex Specifies which position on the slice to return the coordinate of. |
| xlPieSliceLocation Specifies the horizontal or vertical position of a point on a pie chart, in points, from the top or left edge of the object to the top or left edge of the chart area. |
| xlPivotFieldRepeatLabels Specifies whether to repeat all field item labels in a Pivot Table report. |
| xlPortugueseReform Specifies the mode for checking the spelling of Portuguese. |
| xlProtectedViewCloseReason Specifies how the Protected View window was closed. |
| xlProtectedViewWindowState Specifies the state of the Protected View window. |
| xlSlicerCrossFilterType Specifies the type of cross filtering used by the specified slicer cache and how it is visualized. |
| xlSlicerSort Specifies whether items displayed in the slicer are sorted, and if they are sorted, whether they are sorted in ascending or descending order by item captions. |
| xlSpanishModes Specifies the mode for checking the spelling of Spanish. |
| xlSparklineRowCol Specifies how to plot the sparkline when the data on which it is based is in a square-shaped range. |
| xlSparkScale Specifies how the minimum or maximum value of the vertical axis of the sparkline is scaled relative to other sparklines in the group. |
| xlSparkType Specifies the type of sparkline. |
Added in 2007
| xlAboveBelow | Specifies if the values are above or below average. |
| xlActionType | Specifies the action that should be performed. |
| xlCalcFor | Specifies what should be calculated. |
| xlChartElementPosition | Specifies the position of the chart element. |
| xlCheckInVersionType | Specifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library. |
| xlConditionValueTypes | Specifies the types of condition values that can be used. |
| xlConnectionType | Specifies the type of database connection. |
| xlContainsOperator | Specifies the operator used in a function. |
| xlCredentialsMethod | Specifies the type of credentials method used. |
| xlCubeFieldSubType | Specifies the subtype of the CubeField. |
| xlDupeUnique | Specifies whether duplicate or unique values shoud be displayed. |
| xlDynamicFilterCriteria | Specifies the filter criterion. |
| xlFilterAllDatesInPeriod | Specifies how dates should be filtered in the specified period. |
| xlFixedFormatQuality | Specifies the quality of speadsheets saved in different fixed formats. |
| xlFixedFormatType | Specifies the type of file format. |
| xlFormatFilterTypes | Specifies the types of format filters. |
| xlGenerateTableRefs | Specifies the type of table references. |
| xlGradientFillType | Specifies the type of gradient fill. |
| xlIconSet | Specifies the type of icon set. |
| xlLayoutRowType | Specifies the type of layout row. |
| xlLookFor | Specifies what to look for in searches. |
| xlMeasurementUnits | Specifies the measurement units. |
| xlPivotConditionScope | This enumeration specifies the conditional formatting applied for filtering values from the Pivot Table object. |
| xlPivotFilterType | The type of filter applied. |
| xlPivotLineType | Specifies the type of the PivotLine. |
| xlPropertyDisplayedIn | Specifies where to display the property. |
| xlRemoveDocInfoType | Specifies the type information to be removed from the document information. |
| xlRgbColor | Specifies the RGB color. |
| xlSortOn | Specifies the parameter on which the data should be sorted. |
| xlStdColorScale | Specifies the standard color scale. |
| xlTableStyleElementType | Specifies the table style element used. |
| xlThemeColor | Specifies the theme color to be used. |
| xlThemeFont | Specifies the theme font to use. |
| xlThreadMode | Specifies the control over the multi-threaded calculation mode. |
| xlTimePeriods | Specifies the time period. |
| xlTopBottom | Specifies the top 10 values from the top or bottom of a series of values. |
| xlAboveBelow Specifies if the values are above or below average. |
| xlActionType Specifies the action that should be performed. |
| xlCalcFor Specifies what should be calculated. |
| xlChartElementPosition Specifies the position of the chart element. |
| xlCheckInVersionType Specifies the type of version for the document checked in when using the CheckIn method. Applies to workbooks stored in a SharePoint library. |
| xlConditionValueTypes Specifies the types of condition values that can be used. |
| xlConnectionType Specifies the type of database connection. |
| xlContainsOperator Specifies the operator used in a function. |
| xlCredentialsMethod Specifies the type of credentials method used. |
| xlCubeFieldSubType Specifies the subtype of the CubeField. |
| xlDupeUnique Specifies whether duplicate or unique values shoud be displayed. |
| xlDynamicFilterCriteria Specifies the filter criterion. |
| xlFilterAllDatesInPeriod Specifies how dates should be filtered in the specified period. |
| xlFixedFormatQuality Specifies the quality of speadsheets saved in different fixed formats. |
| xlFixedFormatType Specifies the type of file format. |
| xlFormatFilterTypes Specifies the types of format filters. |
| xlGenerateTableRefs Specifies the type of table references. |
| xlGradientFillType Specifies the type of gradient fill. |
| xlIconSet Specifies the type of icon set. |
| xlLayoutRowType Specifies the type of layout row. |
| xlLookFor Specifies what to look for in searches. |
| xlMeasurementUnits Specifies the measurement units. |
| xlPivotConditionScope This enumeration specifies the conditional formatting applied for filtering values from the Pivot Table object. |
| xlPivotFilterType The type of filter applied. |
| xlPivotLineType Specifies the type of the PivotLine. |
| xlPropertyDisplayedIn Specifies where to display the property. |
| xlRemoveDocInfoType Specifies the type information to be removed from the document information. |
| xlRgbColor Specifies the RGB color. |
| xlSortOn Specifies the parameter on which the data should be sorted. |
| xlStdColorScale Specifies the standard color scale. |
| xlTableStyleElementType Specifies the table style element used. |
| xlThemeColor Specifies the theme color to be used. |
| xlThemeFont Specifies the theme font to use. |
| xlThreadMode Specifies the control over the multi-threaded calculation mode. |
| xlTimePeriods Specifies the time period. |
| xlTopBottom Specifies the top 10 values from the top or bottom of a series of values. |
© 2025 Better Solutions Limited. All Rights Reserved. © 2025 Better Solutions Limited TopPrevNext