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 Tables: How 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:
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)
Find What: 2013
Replace With: 2012
Now click Replace All to replace 2013 with 2012;
Now here we have all values replaced 2013 with 2012;