<div>
Thanks Kevin - appreciate the fast response!<br />
<br />
Are you aware of any non-VB way of doing this? &nbsp;If not, that's OK. &nbsp;Thanks!
</div>


Thanks Kevin - appreciate the fast response!

Are you aware of any non-VB way of doing this?  If not, that's OK.  Thanks!

<div>
Nope. This is a known problem with pivot caches.<br />
<br />
Kevin
</div>


Nope. This is a known problem with pivot caches.

Kevin

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
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. &nbsp;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).<br />
<br />
Is there an option in 2007 to ensure historical values are not retained?<br />
<br />
Thanks!
</div>
</div>


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?

Thanks!

Excel 2007 Pivot drop downs filters retain historical data

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.