SlicerPivotTables Interface
Represents information about the collection of PivotTables associated with the specified SlicerCache object.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
<GuidAttribute("000244CB-0000-0000-C000-000000000046")> _
<InterfaceTypeAttribute()> _
Public Interface SlicerPivotTables _
Inherits IEnumerable
'Usage
Dim instance As SlicerPivotTables
[GuidAttribute("000244CB-0000-0000-C000-000000000046")]
[InterfaceTypeAttribute()]
public interface SlicerPivotTables : IEnumerable
Remarks
The SlicerPivotTables collection contains information about the PivotTables the slicer cache is currently filtering. It provides properties for determining the number of PivotTables the slicer is associated with, and for retrieving PivotTable objects that represent the PivotTables being filtered. It also provides methods for adding and removing PivotTables from the SlicerPivotTables collection. The SlicerPivotTables collection will be empty if the slicer associated with the specified SlicerCache is not connected to any PivotTables.
Use the PivotTables property of the SlicerCache object to return the SlicerPivotTables collection associated with a SlicerCache, which in turn may be associated with one or more slicers.