Clear Old Items in an Excel Pivot Table


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

1 thought on “Clear Old Items in an Excel Pivot Table”

Comments are closed.