To totally unlock this section you need to Log-in
Login
After you change the source data for a pivot table, the old items might still appear in the drop downs. The instructions below will help you clear those items.
Old Items Remain in Pivot Field Dropdowns
The data in the pivot table source may change, and items that were previously in the source are no longer included. For example, some sales reps may leave the company, and the names of their replacements appear in the source table.
To totally unlock this section you need to Log-in
Login
Clear Old Items in an Excel Pivot Table – http://heelpbook.altervista.org/?p=36863 – HeelpBook – Visit http://www.heelpbook.net OR http://mobile.heelpbook.net on your tablet! #heelpbook @heelpbook