SlicerCache.SortItems property (Excel)
Returns or sets the sort order of the items in the slicer. Read/write xlSlicerSort .
expression A variable that represents a 'SlicerCache' object.
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.