Edit

Share via


SlicerCache.SlicerItems Property

Definition

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

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

Property Value

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

Remarks

Read-only.

The SlicerItems property of the SlicerCache object is only applicable for slicers that are based on PivotTables based on workbook ranges or lists (SlicerCache.SourceType = xlDatabase), or for slicers that are based on PivotTables based on relational data sources (SlicerCache.SourceType = xlExternal and SlicerCache.OLAP = false). Attempting to access the SlicerItems property for slicers that are connected to an external OLAP data source (SlicerCache.OLAP = true) generates a run-time error. For OLAP data sources, use the SlicerItems property of the SlicerCacheLevel object instead.

Applies to