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

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

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


Phil Smith wrote:
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
Contextures
http://www.contextures.com/tiptech.html

Worked perfectly. thank you.



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

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


Phil Smith wrote:

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