Edit

Share via


SlicerCache.VisibleSlicerItems Property

Definition

Gets a SlicerItems collection that contains the collection of all the visible items in the specified slicer cache.

public:
 property Microsoft::Office::Interop::Excel::SlicerItems ^ VisibleSlicerItems { Microsoft::Office::Interop::Excel::SlicerItems ^ get(); };
public Microsoft.Office.Interop.Excel.SlicerItems VisibleSlicerItems { get; }
Public ReadOnly Property VisibleSlicerItems As SlicerItems

Property Value

A SlicerItems collection that contains the collection of all the visible items in the specified slicer cache.

Remarks

Read-only.

The VisibleSlicerItems property is only applicable for slicers that are based on PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase). Attempting to access the VisibleSlicerItems property for slicers that are connected to an OLAP data source (SlicerCache.OLAP = true) generates a run-time error.

Applies to