Pivot Table Problem

[need_help_with_excel]

I have just found out that Pivot Tables keep a history of old data and
includes them with the new ones in the list for that particular data
field, and because I only want the new data - I have to manually go in
the drop down list for that data field and uncheck the old data so that
it won't appear in the table.

Does anyone know how to stop the old data from appearing in the drop
down list so that it only shows the new data as options?

This would help me a lot. Thanks in advance =)

 

[Debra Dalgleish]

There's information here on clearing old items in a pivot table:

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