I have massive pivot tables that are refreshed on every month. When I
override the prior months data the drop down lists do not refresh, old values
are still present even though the values are no longer there.

example:
month 1: column A has 4 values: forecast, actual, plan, projected
Month 2: I delete plan as a value yet it still appears.

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

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


pivot table drop down values wrote:
I have massive pivot tables that are refreshed on every month. When I
override the prior months data the drop down lists do not refresh, old values
are still present even though the values are no longer there.

example:
month 1: column A has 4 values: forecast, actual, plan, projected
Month 2: I delete plan as a value yet it still appears.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Thanks that is awesome and your response was so quick!!! So sad that this
jsut made my day and its Saturday!lol



tables that are refreshed on every month. When I
override the prior months data the drop down lists do not refresh, old values
are still present even though the values are no longer there.

example:
month 1: column A has 4 values: forecast, actual, plan, projected
Month 2: I delete plan as a value yet it still appears.

You're welcome! Thanks for letting me know that it helped.

pivot table drop down values wrote:
Thanks that is awesome and your response was so quick!!! So sad that this
jsut made my day and its Saturday!lol



tables that are refreshed on every month. When I

override the prior months data the drop down lists do not refresh, old values
are still present even though the values are no longer there.

example:
month 1: column A has 4 values: forecast, actual, plan, projected
Month 2: I delete plan as a value yet it still appears.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html