Information
The topic you requested is included in another documentation set. For convenience, it's displayed below. Choose Switch to see the topic in its original location.

PivotTable.ClearTable Method

Office 2007
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.

Version Information
 Version Added:  Excel 2007

Syntax

expression.ClearTable

expression   A variable that represents a PivotTable object.

Remarks

The ClearTable function takes no arguments and is available for both relational and OLAP PivotTables.

Example

The following example clears a PivotTable on the active worksheet.

Visual Basic for Applications
ActiveSheet.PivotTables(1).ClearTable()



Community Additions

Show: