Video Tutorial -How To Delete Obsolete Items From Pivot Table


If you reuse your pivot tables over and over again but your source data changes then you may find you have old items remaining in the TabLe Field Drop downs. In Excel 2007 it’s really easy to deal with. Watch this short video tutorial on how to use the Change Retain Items Function in Excel to remove these old redundant items.

 

 

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts