Excel.SlicerItems.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SlicerItems object (Excel)	vbaxl10.chm908072	vbaxl10.chm908072	Excel.SlicerItems	80bbbbab-711a-cefb-255b-94fe2994d3c8	04/02/2019	medium

SlicerItems object (Excel)

Represents the collection of SlicerItem objects contained in a SlicerCache or SlicerCacheLevel object.

Remarks

To access the SlicerItems collection that represents the items in a slicer based on data in the workbook or non-OLAP external data, use the SlicerItems property of the SlicerCache object that is associated with the slicer.

To access the SlicerItems collection that represents the items in a slicer based on an OLAP data connection, use the SlicerItems property of the SlicerCacheLevel object that represents a level of the hierarchy.

Properties

• Application
• Count
• Creator
• Item
• Parent

See also

• Excel Object Model Reference

[!includeSupport and feedback]