SlicerCache.SortItems property (Excel)

Returns or sets the sort order of the items in the slicer. Read/write xlSlicerSort .

Syntax

expression. SortItems

expression A variable that represents a 'SlicerCache' object.

Return value

xlSlicerSort

Remarks

The default setting of this property is xlSlicerSortAscending .

The SortItems property of the SlicerCache object only applies to slicers that are based on PivotTables that are connected to workbook ranges or lists (SlicerCache . SourceType = xlDatabase). Attempting to access the SortItems property for slicers that are connected to a OLAP data sources (SlicerCache . OLAP = True) generates a run-time error. For OLAP data sources, use the SortItems property of the SlicerCacheLevel object instead.

See also

SlicerCache Object