Excel 2007 Pivot drop downs filters retain historical data
Posted on 2011-02-27
We recently migrated over to Excel 2007 and I'm noticing something strange with a few pivot tables I have in the background of a few reporting templates.
When I clear out old data and drop in new data, the drop downs in the pivot table that allow you to filter, not only have the new values but also the old values. For example, my pivot is set to show all values which returns 10 rows of data, however the drop down shows close to 100 different values to chose from (note - everything is selected).
Is there an option in 2007 to ensure historical values are not retained?