SlicerCache SlicerCache SlicerCache Interface


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

public interface class SlicerCache
public interface SlicerCache
Public Interface SlicerCache


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.


Application Application Application

When used without an object qualifier, this property gets an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property gets an Application object that represents the creator of the specified object.

Creator Creator Creator

Gets a 32-bit integer that indicates the application in which this object was created.

CrossFilterType CrossFilterType CrossFilterType

Gets or sets whether a slicer is participating in cross filtering with other slicers that share the same slicer cache, and how cross filtering is displayed.

FilterCleared FilterCleared FilterCleared

Returns whether the slicer or timeline filter state is cleared. Boolean (bool in C#). Read-only

Index Index Index

Gets the index of the specified SlicerCache object in the SlicerCaches collection.

List List List

True if the slicer cache is for a slicer on a table. False otherwise. Boolean (bool in C#) Read-only

ListObject ListObject ListObject

Returns a ListObject object for the QueryTable object. Read-only

Name Name Name

Gets or sets the name of the slicer cache.


Gets whether the slicer associated with the specified slicer cache is based on an OLAP data source.

Parent Parent Parent

Gets the parent SlicerCaches object for the specified SlicerCache object.

PivotTables PivotTables PivotTables

Gets a SlicerPivotTables collection that contains information about the PivotTables the slicer cache is currently filtering.

RequireManualUpdate RequireManualUpdate RequireManualUpdate

True when manual updates of the slicer cache required. Boolean (bool in C#) Read/Write

ShowAllItems ShowAllItems ShowAllItems

Gets or sets whether slicers connected to the specified slicer cache display items that have been deleted from in the corresponding PivotCache.

SlicerCacheLevels SlicerCacheLevels SlicerCacheLevels

Gets the collection of SlicerCacheLevel objects that represent the levels of an OLAP hierarchy on which the specified slicer cache is based.

SlicerCacheType SlicerCacheType SlicerCacheType

Returns the type of the slicer cache – slicer or timeline. Read-only

SlicerItems SlicerItems SlicerItems

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

Slicers Slicers Slicers

Gets a Slicers collection that contains the collection of Slicer objects associated with the specified SlicerCache.

SortItems SortItems SortItems

Gets or sets whether the items in the slicer are sorted.

SortUsingCustomLists SortUsingCustomLists SortUsingCustomLists

Gets or sets whether items in the specified slicer cache will be sorted by the custom lists.

SourceName SourceName SourceName

Gets the name of the data source the slicer is connected to.

SourceType SourceType SourceType

Gets the kind of data source the slicer is connected to.

TimelineState TimelineState TimelineState

The timeline-specific state of the SlicerCache object. Read-only

VisibleSlicerItems VisibleSlicerItems VisibleSlicerItems

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

VisibleSlicerItemsList VisibleSlicerItemsList VisibleSlicerItemsList

Gets or sets the list of MDX unique names for members at all levels of the hierarchy where manual filtering is applied.

WorkbookConnection WorkbookConnection WorkbookConnection

Gets a WorkbookConnection object that represents the data connection used by the specified slicer.


ClearAllFilters() ClearAllFilters() ClearAllFilters()

Clears the filter for either slicer or timeline, depending on the slicer cache type.

ClearDateFilter() ClearDateFilter() ClearDateFilter()

Clears the filter for a timeline (date filter).

ClearManualFilter() ClearManualFilter() ClearManualFilter()

Clears the filtering of all slicers associated with the specified slicer cache.

Delete() Delete() Delete()

Deletes the specified slicer cache and the slicers associated with it.

Applies to