Clear & Delete Old Pivot Table Items

Did you have ever tried to clear/delete/replace your Pivot Table data or items but then found that it is still showing inside your Pivot Table filters? I’m sure you have faced this problem. So don’t worry here in this blog I’m going to solve this problem for you; within 5 steps you will be able to clear or delete the pivot table items/data permanently from the Pivot Table’s memory or you can say Pivot Table’s Cache. 

Previously In Pivot TablesHow to Automatically Refresh a Pivot Table in Excel?

In this blog I’ll show you below given mine Pivot Table with the Years showing in the Column area (2013,2014) as an example:

Clear & Delete Old Pivot Table Items

STEP1: Find & Replace

There’s my data source and I need to replace the year 2013 with 2012, it means I only want to show the 2012 & 2014 years. So, for this follow the following:

Go to Home > Find & Select > Replace (or CTRL+H)

Clear & Delete Old Pivot Table Items

Now Input;

Find What: 2013
Replace With: 2012

Clear & Delete Old Pivot Table Items

Now click Replace All to replace 2013 with 2012;

Clear & Delete Old Pivot Table Items

Now here we have all values replaced 2013 with 2012;

Clear & Delete Old Pivot Table Items