Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft Excel > How to Delete a Pivot Table in Excel? 4 Best Methods

How to Delete a Pivot Table in Excel? 4 Best Methods

Note: This tutorial on how to delete a pivot table in Excel is suitable for all Excel versions including Office 365. 

If you are a regular Excel user, you may already know that the Pivot table is one of the most versatile Excel features. It allows you to slice and dice your data as per your needs and helps you to draw quick insights from the dataset. 

But, more often than not, Pivot tables tend to encumber an Excel workbook’s performance. This happens especially when they are overused or if the data set is huge. 

Related:

How to Extract an Excel Substring? – 6 Best Methods

How to Superscript in Excel? (9 Best Methods)

How To Find Duplicates in Excel? (3 Easy Methods)

The main reason behind this is that Pivot tables increase the Excel file size considerably and consume more memory and processing power. 

Hence, it is advisable to delete Pivot tables after using them. But, it is not as simple as it sounds. 

In this tutorial, I’ll show you how to delete a Pivot table in Excel without any hiccups. 

How to Delete a Pivot Table? 4 Approaches

Depending on your requirements, you may need to use one of the following four approaches in your workbook. 

  1. How to Delete a Pivot Table but Keep the Data?
  2. Keep the Pivot Table but Delete the Data
  3. Delete the Pivot Table Along with its Data
  4. Delete all Pivot Tables in the Entire Workbook.

I’ll explain each one of these methods with detailed examples in the following section. 

How to Delete a Pivot Table but Keep the Data?

delete the pivot table but keep the data

This is one of the frequently asked questions about Pivot tables. How to delete a pivot table but keep its values?
All you have to do is just copy the entire Pivot table and paste it as values in some other suitable location. 
Follow these steps to do this easily: 

Step 1

select any pivot table cell

Click on any Pivot Table cell.

Step 2

An “Analyze” tab will appear in the ribbon as soon as you do this. Click on it. 

Step 3

Then under it, click on the Select option and choose Entire PivotTable.

Step 4

Press Ctrl+C to copy the Pivot Table and go to a suitable location where you need to place the Pivot Table data.

Step 5

Press Alt+E+S+V to paste the data as values. 

Step 6

Go back to the Pivot Table, select all values using Ctrl+A and hit the delete button.

Keep the Pivot Table but Delete the Data

This is another common requirement that users face. Sometimes, you need to just clear the Pivot Table and start again with a fresh summary without deleting it. 

To do this, follow these steps: 

  1. Click on any Pivot Table cell.
  1. An “Analyze” tab will appear in the ribbon as soon as you do this. Click on it. 
Go to the PivotTable Analyze tab and click on Clear > Clear All
Go to the PivotTable Analyze tab and click on Clear > Clear All
  1. Then under it, click on the Clear button and choose Clear All.

Now, the Pivot table will remain, but its data will be cleared. 

Also Read:

How to Use Goal Seek in Excel? (3 Simple Examples)

How to Insert Multiple Rows in Excel? The 4 Best Methods

How to Autofit Excel Cells? 3 Best Methods

Delete the Pivot Table Along with its Data

This is a pretty straightforward requirement. 

The best way to do this is to just delete the Sheet that contains the Pivot table, provided if there is no other data in that particular sheet. 

Or else, click on any cell inside the Pivot Table and press Ctrl+A to select the entire Pivot table and hit delete. This method will not select the entire Pivot Table if filters are applied.

To avoid this, the foolproof method is to do the following:

  1. Click on any Pivot Table cell.
  1. An “Analyze” tab will appear in the ribbon as soon as you do this. Click on it. 
  1. Then under it, click on the Select option and choose Entire PivotTable.
Click on Select > Entire PivotTable under PivotTable Analyze tab
Click on Select > Entire PivotTable under PivotTable Analyze tab
  1. Now, your entire Pivot Table is selected including filtered data if any. Hit the delete key. 

Delete all Pivot Tables in the Entire Workbook

This process of manually deleting Pivot tables can become very tiresome, especially if you have a lot of them in your workbook. 

There is a simpler way to handle this by running a VBA code. 

Don’t worry, it is very easy to do. Just follow these simple steps:

  1. Hit Alt+F11 to open the VBA editor. 
Press Alt+F11 to access the Excel VBA Editor
Press Alt+F11 to access the Excel VBA Editor
  1. In the left-hand pane under Projects, locate your workbook and right-click on any one of the sheets under it. 
  1. Then click on Insert and choose Module. 
Right-click on any sheet in your workbook and click on Insert > Module
Right-click on any sheet in your workbook and click on Insert > Module
  1. A module window will now appear. Paste the following code there.
Sub ClearPivotTables()
Dim Ws As Worksheet, Pt As PivotTable
On Error Resume Next
For Each Ws In ActiveWorkbook.Worksheets
    For Each Pt In Ws.PivotTables
        Pt.TableRange2.Clear
    Next Pt
Next Ws
End Sub

The VBA code is self-explanatory. First, we refer to Worksheets as Ws and PivotTable as Pt. Then, we use a “For” loop to instruct Excel to clear the table range for each pivot table in every worksheet inside the workbook. 

Paste the code in the Module Window
Paste the code in the Module Window
  1. Now hit the Run button in the VBA editor toolbar. 
Click on the Run button in the toolbar
Click on the Run button in the toolbar

Excel will now delete all Pivot Tables in your worksheet automatically. 

Suggested Reads:

How to Group Worksheets in Excel? (In 3 Simple Steps)

How to Shade Every Other Row in Excel? (5 Best Methods)

How to Use the Excel Fill Handle Easily? (Top 3 Uses with Examples)

FAQs

How to delete the Pivot Table cache?

You can delete the Pivot Table cache or share it with multiple pivot tables to reduce calculation times and improve performance. To do this, select the Pivot Table you want to share or delete. Then, go to the Home tab and click on Clear-All. This will clear the cache of the Pivot-Table along with its calculations. Now, you can duplicate it and share the same cache between these two Pivot Tables.

How to delete a calculated field in Pivot Table?

To delete a calculated field in Pivot Table, click anywhere inside it. On the “Pivot Table Analyze” tab click on the Fields, Items & Sets option. Now, click on “Calculated Field”. In the “Name” box choose the field you want to delete and click Delete.

Let’s Wrap Up

That’s all folks. These are the different methods to delete Pivot tables in Excel. Hereafter, use these techniques for a hassle-free Excel experience. If you have any questions regarding this or any other Excel feature, please let us know in the comments. We are always happy to help. 

If you need more high-quality Excel guides, please check out our free Excel resources centre.

Ready to dive deep into Excel? Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 100+ IT training courses. Click here for advanced Excel courses with in-depth training modules.

Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Using Quick Reports in QuickBooks 2019

How to Create Hyperlinks in Microsoft Word 2013

Excel INDIRECT Function—The Best Guide with 5 Examples

How to Record a Macro in Excel? In 6 Easy Steps (For Dummies)

Managing Users and Switching Accounts in Windows 8

How to Record a Bank Transfer in QuickBooks 2019

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)