How To Delete A Pivot Table In Excel (3 Easy Methods) - ExcelDemy

Maybe your like

This is the sample dataset.

how to delete a pivot table

This is the pivot table.

Method 1 – Delete the Pivot Table with the Data Table

Steps:

Select the table. Here, B4:E9.

Delete Pivot Table with Table Data

Press Delete to delete the pivot table.

You can also go to the PivotTable Analysis tab and select the Entire Pivot Table in Select.
Press Delete.

Delete Pivot Table with Table Data

Method 2 – Delete the Pivot Table and keep the Data Table

Steps:

Select a cell in the pivot table report and go to the PivotTable Analyze tab.
Click Select and choose Entire Pivot_Table.

Delete Pivot Table without Table Data

Press Ctrl+C.
Select a cell to keep the data.
Press Ctrl+V.

Press Ctrl and choose Value in Paste Values.

You’ll see the pivot table raw data.

Delete Pivot Table without Table Data

Select the entire table.

Delete Pivot Table without Table Data

Press Delete..

Method 3 – Applying a VBA Code to Delete All Pivot Tables

Steps:

Press Alt+F11.
In the Microsoft Visual Basic for Application, click Insert and select Module.

Applying VBA Code to Delete All the Pivot Tables

Enter the following code.

Sub del_piv_table() Dim w_s As Worksheet Dim Piv_table As PivotTable On Error Resume Next For Each w_s In ActiveWorkbook.Worksheets For Each Piv_table In w_s.PivotTables w_s.Range(Piv_table.TableRange2.Address).Delete Shift:=xlUp Next Piv_table Next w_s End Sub

Applying VBA Code to Delete All the Pivot Tables