SlicerCache.SortItems Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets whether the items in the slicer are sorted.
public:
property Microsoft::Office::Interop::Excel::XlSlicerSort SortItems { Microsoft::Office::Interop::Excel::XlSlicerSort get(); void set(Microsoft::Office::Interop::Excel::XlSlicerSort value); };public Microsoft.Office.Interop.Excel.XlSlicerSort SortItems { get; set; }Public Property SortItems As XlSlicerSortProperty Value
A XlSlicerSort object.
Remarks
Read/write.
The default setting of this property is xlAscending.
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.