We have technically deleted the year 2012 records, so they should be gone from our Pivot Table, right? Let us replace the year 2012 with the year 2013. STEP 1: Below is our data source and we want to replace the year 2012 with 2013, effectively only showing the years 2014 & 2013. ![]() Let’s learn how to fix it!įollow the step-by-step tutorial on How to Clear Pivot Table cache memory and make sure to download the exercise workbook to follow along: ![]() This is because the old item is still saved in the Pivot Table cache memory. But, the year 2012 is still visible in the Pivot Table’s filter selection. Now, you change the year 2012 in your data source to 2013 and the same is reflected in the Pivot Table as well. So, you have created a Pivot Table using the original data source containing the years 2012, 2013, and 2014. Let’s look at an example and understand How to Clear Pivot Table Cache Memory! This can be confusing as well as annoying. ![]() ![]() This is because the old data is stored in the cache memory and displayed in filter selections even if there is no data for it at all. You have deleted or replaced old data from the data table but even after refreshing the pivot table, the data is still visible.
0 Comments
Leave a Reply. |
Details
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |