SlicerCache Properties (Excel)

Office 2013

This object has the following properties:

Name

Description

Application

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

Creator

Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.

CrossFilterType

Returns 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. Read/write

FilterCleared

Returns whether the slicer or timeline filter state is cleared. Boolean. Read-only

Index

Returns the index of the specified SlicerCache object in the SlicerCaches collection. Read-only

List

True if the slicer cache is for a slicer on a table. False otherwise. Boolean Read-only

ListObject

Returns a ListObject object for the QueryTable Object (Excel) object. Read-only

Name

Returns or sets the name of the slicer cache.

OLAP

Returns whether the slicer associated with the specified slicer cache is based on an OLAP data source. Read-only

Parent

Returns the parent SlicerCaches object for the specified SlicerCache object. Read-only.

PivotTables

Returns a SlicerPivotTables collection that contains information about the PivotTables the slicer cache is currently filtering. Read-only

RequireManualUpdate

True when manual updates of the slicer cache required. Boolean Read/Write

ShowAllItems

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

SlicerCacheLevels

Returns the collection of SlicerCacheLevel objects that represent the levels of an OLAP hierarchy on which the specified slicer cache is based. Read-only

SlicerCacheType

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

SlicerItems

Returns a SlicerItems collection that contains the collection of all items in the slicer cache. Read-only

Slicers

Returns a Slicers collection that contains the collection of Slicer objects associated with the specified SlicerCache. Read-only

SortItems

Returns or sets the sort order of the items in the slicer. Read/write XlSlicerSort.

SortUsingCustomLists

Returns or sets whether items in the specified slicer cache will be sorted by the custom lists. Read/write

SourceName

Returns the name of the data source the slicer is connected to. Read-only

SourceType

Returns the kind of data source the slicer is connected to. Read-only

TimelineState

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

VisibleSlicerItems

Returns a SlicerItems collection that contains the collection of all the visible items in the specified slicer cache. Read-only

VisibleSlicerItemsList

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

WorkbookConnection

Gets or sets the WorkbookConnection object that represents the data connection used by the specified slicer. Read/Write.

Show:
© 2015 Microsoft