Share via

SlicerPivotTables.RemovePivotTable Method

  • Article

Removes a reference to a PivotTable from the SlicerPivotTables collection.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
Sub RemovePivotTable ( _
    PivotTable As Object _
)
'Usage
Dim instance As SlicerPivotTables
Dim PivotTable As Object

instance.RemovePivotTable(PivotTable)

void RemovePivotTable(
    Object PivotTable
)

Parameters

  • PivotTable
    Type: System.Object

    A PivotTable object that represents the PivotTable to remove, or the name or index of the PivotTable in the collection.

Remarks

When a PivotTable is removed from the SlicerPivotTables collection, is no longer filtered by its parent SlicerCache and the slicers associated with it.

See Also

Reference

SlicerPivotTables Interface

SlicerPivotTables Members

Microsoft.Office.Interop.Excel Namespace