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.
