How to Remove a Pivot Table in Excel

To summarize data, pivot tables are considered as Excel’s most powerful feature. But there are sometimes, when you might not need them or they take too much space in your workbook. 

In such cases it is very important to know how to remove a pivot table in Excel.

This blog will help you to explain different methods to remove a pivot table, whether you want to delete it completely, keep only the results, or clear it for reuse.

Why Remove a Pivot Table in Excel?

Before knowing about the methods, you need to know the most common reasons why users remove pivot tables:

• To declutter the workbook as too many pivot tables can make a file messy.
• To improve performance as pivot tables increase file size and this might slow Excel.
• To preserve the values only as sometimes, users want the numbers but not the pivot functionality.
• To reset the structure as you may want to start fresh with the same pivot table container.

When you get to understand these reasons you can use the right method to remove pivot tables in excel.

Method 1: Delete the Pivot Table Completely

To delete the pivot table completely you can follow the following steps:

• Click anywhere inside the pivot table
• Go to the PivotTable Analyze tab.
• In the Actions group, click Select → Entire PivotTable.
• Press the Delete key.

As a result you will see that the pivot tables and its results are removed but the data remains intact.

An alternative way is to use Ctrl + A inside the pivot table and then press Delete. 

Method 2: Remove the Pivot Table but Keep the Results

To drop the pivot table functionality while keeping the numbers and formatting you need to follow these steps: 

• Select the entire pivot table (Analyze → Select → Entire PivotTable).
• Right-click and choose Copy.
• On the Home tab, click Paste → Values.

As a result you will see that you will have only static values instead of a pivot table. This method is useful when you want a snapshot of results without the risk of accidental changes.

Method 3: Clear the Pivot Table (Reset Without Deleting)

If you want to reset the pivot table but keep its shell for reuse follow the given steps:

• Click inside the pivot table.
• Go to the Analyze tab → Actions group.
• Click Clear → Clear All.

As a result you will see that all fields, filters and formatting are removed. The pivot table remains as a blank container ready for new data. This is best when you want to rebuild or repurpose an existing pivot table.

Method 4: Delete All Pivot Tables at Once (VBA Method)

For workbooks with many pivot tables, deleting them one by one can be 

For workbooks with many pivot tables, deleting them one by one can be boring. A simple VBA macro can remove all pivot tables in one go:

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

To run this press Alt+F11 to open the VBA editor. After that, go to Insert → Module. Paste the code and run it. Paste the code and then run it.

This program deletes all pivot tables permanently. So, make sure to always keep a backup.

Common Errors and its Solutions

Things to Remember before Deleting Pivot Tables

• Always keep a backup of your file, especially if you are using VBA or mass deletion.
• Always check dependencies to ensure other reports are not linked to the pivot table.
• If you want to keep data for reference, always paste as values first.
• Instead of deleting, reset the pivot table if you might use it again.