SlicerPivotTables Members (Excel)

Article
05/23/2016

GitHub-Mark-64px

Contribute to this content

Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation.

Represents information about the collection of PivotTables associated with the specified SlicerCache object.

Methods

Name	Description
AddPivotTable	Adds a reference to a PivotTable to the SlicerPivotTables collection.
RemovePivotTable	Removes a reference to a PivotTable from the SlicerPivotTables collection.

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.
Count	Returns the number of objects in the collection.
Creator	Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long.
Item	Returns a single PivotTable object from the collection.
Parent	Returns the SlicerCache object that is the parent of the specified SlicerPivotTables collection. Read-only.