SlicerPivotTables.AddPivotTable Method
Adds a reference to a PivotTable to the SlicerPivotTables collection.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub AddPivotTable ( _
PivotTable As PivotTable _
)
'Usage
Dim instance As SlicerPivotTables
Dim PivotTable As PivotTable
instance.AddPivotTable(PivotTable)
void AddPivotTable(
PivotTable PivotTable
)
Parameters
PivotTable
Type: Microsoft.Office.Interop.Excel.PivotTableA PivotTable object that represents the PivotTable to add.
Remarks
When a PivotTable is added to the SlicerPivotTables collection, it can be filtered by its parent SlicerCache and the slicers associated with it.