Refreshing pivot table drop down lists

[Rick Lewis]

How do I get rid of old values in pivot table drop down
lists? The original data has been deleted for months,
even years, yet, the pivot table drop down still shows
them and I have to scroll through the entire list in order
to check off the ones I want to use.

Thanks.

 

[Debra Dalgleish]

There are instructions here for clearing old items from the dropdown lists:

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

 

[Rick Lewis]

Awesome Debra - Thank you!!

There are instructions here for clearing old items from the dropdown lists:

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