How to delete one or all pivot tables in Excel?
Pivot table is a very useful function for viewing or calculating data in Excel, so we may usually insert Pivot tables into a worksheet or multiple worksheets. But do you know how to delete one or all pivot tables in a worksheet or the whole workbook?
Excel Productivity Tools
Office Tab: Bring powerful tabs to Office (include Excel), just like Chrome, Safari, Firefox and Internet Explorer. Save you half the time, and reduce thousands of mouse clicks for you. 30-day Unlimited Free Trial
Kutools for Excel: Save 70% of your time and solve 80% Excel problems for you. 300+ advanced features designed for 1500+ work scenario, make Excel much easy and increase productivity immediately. 60-day Unlimited Free Trial
In Excel, you can delete one pivot table as follow:
1. Click the pivot table report. See screenshot:
2. Then click Option > Select > Entire PivotTable to select then pivot table. See screenshot:
Tip: If you are using Excel 2013, please select the entire pivot table with clicking the Analyze > Select > Entire PivotTable.
3. And press Delete button on the keyboard, the pivot table will be removed.
If you have multiple pivot tables in a workbook, delete them one by one is too time-consuming. Now you can use a VBA to remove them at once.
1. Press Alt + F11 to display the Microsoft Visual Basic for Applications window.
2. In the window, click Insert > Module to show a new module window, then copy the following VBA code into the module window.
VBA: Remove all pivot tables in the whole workbook.
Sub DeleteAllPivotTablesInWorkbook() 'Updateby20140618 Dim xWs As Worksheet Dim xPT As PivotTable For Each xWs In Application.ActiveWorkbook.Worksheets For Each xPT In xWs.PivotTables xWs.Range(xPT.TableRange2.Address).Delete Shift:=xlUp Next Next End Sub3. Click Run button, then all pivot tables in the whole workbook are removed.