SlicerItems Object (Excel)

Office 2013 and later
GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

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

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 OLAP data connection, use the SlicerItems property of the SlicerCacheLevel object that represents a level of the hierarchy.

Show: