Pivot Table Field History

[jlbenton76]

I have a pivot table set up that I am updating information in a "raw data
worksheet". I delete old records and add new records. Within the field
listing, older records are not going away even though there is not a field in
the "raw data worksheet" to reference. Is there a way to delete history, or
get the history to update when refreshing the pivot table?

Thanks!

Josh

 

[Debra Dalgleish]

Depending on which version of Excel you're using, you might also be able
to change a pivot table setting, so the old items don't reappear.

There are instructions here:

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