Excel.SlicerCacheLevel.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
SlicerCacheLevel object (Excel)	vbaxl10.chm900072	vbaxl10.chm900072	Excel.SlicerCacheLevel	d73ff7ab-4d7a-6a73-3716-11dc6716688d	04/02/2019	medium

SlicerCacheLevel object (Excel)

Represents a level of a hierarchy in an OLAP data source being filtered by a slicer.

Remarks

When a slicer is used to filter an OLAP data source, the slicer cache that it is associated with can contain multiple hierarchy levels from the data source.

Use the SlicerCacheLevels collection of the parent SlicerCache object to access the SlicerCacheLevel objects that represent these hierarchy levels.

Properties

• Application
• Count
• Creator
• CrossFilterType
• Name
• Ordinal
• Parent
• SlicerItems
• SortItems
• VisibleSlicerItemsList

See also

• Excel Object Model Reference

[!includeSupport and feedback]