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.PivotTable

  A 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.

See Also

Reference

SlicerPivotTables Interface

SlicerPivotTables Members

Microsoft.Office.Interop.Excel Namespace