This topic has not yet been rated - Rate this topic

SlicerCache.SlicerItems Property (Excel)

Published: July 16, 2012

Returns a SlicerItems collection that contains the collection of all items in the slicer cache. Read-only

Version Added: Excel 2010

expression .SlicerItems

expression A variable that represents a SlicerCache object.

Return Value


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.

Community Additions

© 2014 Microsoft. All rights reserved.