SlicerCache.SlicerItems Property (Excel)
Returns a SlicerItems collection that contains the collection of all items in the slicer cache. Read-only
Version Information
Version Added: Excel 2010
Syntax
expression .SlicerItems
expression A variable that represents a SlicerCache object.
Return Value
SlicerItems
Remarks
The SlicerItems property of the SlicerCache object is only applicable for slicers that are based on PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase), or for slicers that are based on PivotTables based on relational data sources (SlicerCache.SourceType = xlExternal and SlicerCache.OLAP = False). Attempting to access the SlicerItems property for slicers that are connected to an external OLAP data source (SlicerCache.OLAP = True) generates a run-time error. For OLAP data sources, use the SlicerItems property of the SlicerCacheLevel object instead.