PivotTable.ClearTable Method
The ClearTable() method is used for clearing a PivotTable. Clearing PivotTables includes removing all the fields and deleting all filtering and sorting applied to the PivotTables. This method resets the PivotTable to the state it had right after it was created, before any fields were added to it.
Namespace: Microsoft.Office.Interop.Excel
Assembly: Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)
Syntax
'Declaration
Sub ClearTable
'Usage
Dim instance As PivotTable
instance.ClearTable()
void ClearTable()
Remarks
The ClearTable() function takes no arguments and is available for both relational and OLAP PivotTables.