My Data had a coloum containing stuff like

Marketing Department
Sales Department
Shipping Department

I built a bunch of pivot tables on this data. Then I changed the data
to read:

Marketing Dept
Sales Dept
Shipping Dept

and performed a Refresh Data.

Now, on the filter pulldowns on any of the Pivot tables, I see
Marketing Department
Sales Department
Shipping Department
Marketing Dept
Sales Dept
Shipping Dept

The first three option no longer exist in any of the data, and I do not
want them in the list. How to fix this problem without recreating and
reformatting 38 seperate Pivot tables?

Thanx