Skip to content

Latest commit

 

History

History
40 lines (22 loc) · 1.36 KB

Excel.SlicerCache.SlicerItems.md

File metadata and controls

40 lines (22 loc) · 1.36 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
SlicerCache.SlicerItems property (Excel)
vbaxl10.chm897083
vbaxl10.chm897083
Excel.SlicerCache.SlicerItems
d552a519-3d9f-74b8-4cbe-3b5c935a14d9
05/16/2019
medium

SlicerCache.SlicerItems property (Excel)

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

Syntax

expression.SlicerItems

expression A variable that represents a SlicerCache object.

Return value

SlicerItems

Remarks

The SlicerItems property 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.

[!includeSupport and feedback]