Removing old Row and Column Items from the Pivot Table


EXCEL UNPLUGGED

Pivot tables still remains the go to solution in Excel for Data Analysis. And for those who do work with them on a regular basis, three things begin to bother them soon. One is the automatic resizing of columns on Pivot Table refresh which you can read about here. The second is, that If you use the same data set to create many Pivot Tables, they are all connected to the same Data Cache and therefor all update at the same time, all use the same grouping on lables and so on. If you want  to know how to resolve this, you can read about it here.  This article will address the third issue with the Pivot Table command that enables you to still see the leftover entries that no longer exist in the data table. We will also talk about how to remove them…

Here is an…

View original post 400 more words