SlicerCacheLevel.VisibleSlicerItemsList Property (Excel)

Returns the list of slicer items that are currently included in the slicer filter. Read-only

Version Information

Version Added: Excel 2010

Syntax

expression .VisibleSlicerItemsList

expression A variable that represents a SlicerCacheLevel object.

Return Value

Variant

Remarks

The list of slicer items are returned as MDX unique name strings. If this list is empty, the slicer is not filtering the data source and all slicer tiles are displayed as selected.

See Also

Concepts

SlicerCacheLevel Object

SlicerCacheLevel Object Members