SlicerCache Interface

Represents the current filter state for a slicer and information about which PivotCache or WorkbookConnection the slicer is connected to.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
<GuidAttribute("000244C4-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface SlicerCache
'Usage
Dim instance As SlicerCache
[GuidAttribute("000244C4-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface SlicerCache

Remarks

Use the SlicerCaches property of the _Workbook object to access the collection of SlicerCache objects in a workbook.

Each slicer has a base SlicerCache object which represents the items displayed in the slicer and the current user interface state of the tiles displayed with their corresponding item captions. Each slicer control that the user sees in Excel is represented by a Slicer object that has a SlicerCache object associated with it.

See Also

Reference

SlicerCache Members

Microsoft.Office.Interop.Excel Namespace