Pivot Table Refresh

[pivot table drop down values]

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]

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

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

 

[pivot table drop down values]

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

 

[Debra Dalgleish]

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