Pivot Table Refresh

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I save Pivot Table Data 4
pivot tables - number of columny but need a column for each month 2
Pivot Table Refresh? 1
Pivot Table Refreshing of Data 1
How to refresh drop-down list of pivot table 3
Pivot table drop downs not refreshing 1
Pivot Tables 4
Refreshing a pivot table 1

Back
Top