Excel.SlicerItem.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SlicerItem object (Excel)	vbaxl10.chm906072	vbaxl10.chm906072	Excel.SlicerItem	cb93cd82-fc3a-f6b7-ae64-db6312db649d	04/02/2019	medium

SlicerItem object (Excel)

Represents an item in a slicer.

Remarks

To access the SlicerItem object that represents the currently selected button in the slicer, use the ActiveItem property of the Slicer object.

To access the SlicerItems collection that represents all the items in a slicer filtering a PivotTable, use the SlicerItems property of the SlicerCache object that is associated with the Slicer object.

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

Properties

• Application
• Caption
• Creator
• HasData
• Name
• Parent
• Selected
• SourceName
• SourceNameStandard
• Value

See also

• Excel Object Model Reference

[!includeSupport and feedback]