Have 100s of Pivot tables that organize data base on a list of companies. The list of companies if dynamic. It seems that even after a company has been removed from the data source the pivot tables still remembers the company name. These Pivot Tables have been used years and drop down list to select which companies to include in the pivot tables is becoming cumbersom to work (There are case where I have the same company spell differently or abbreviated in the list). Does any one know how to remove the old information from the hide/show list? I am in desperate need of help!!! At this point recreating all 200 Pivot Tables is not an option.