영어로 읽기

다음을 통해 공유


SlicerCache.SlicerItems Property (Excel)

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

Version Information

추가된 버전: Excel 2010

Syntax

.SlicerItems

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.

참고 항목

개념

SlicerCache Object Members

SlicerCache Object