Pivot Table Updates Issue

[Phil Smith]

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

 

[Debra Dalgleish]

There are instructions here for clearing old items from a pivot table:

http://www.contextures.com/xlPivot04.html

 

[Phil Smith]

Worked perfectly. thank you.

There are instructions here for clearing old items from a pivot table:

http://www.contextures.com/xlPivot04.html