"How do I get rid of old records in an Pivot Table?

[AyPee]

The spreadsheet gets copied each month to a new file and the data cleared
out, BUT the selecetion in the Pivot Table still holds the data from Previous
spreadsheets

 

[Dave Peterson]

Debra Dalgleish has some techniques at:

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

 

[seth]

The web-link was very helpful, thank you. I was about to reprogram and build
my pivot tables to get rid of the obsolete items. Its weird that they don't
automatically get deleted from the PT records...thanks

 

[AyPee]

Perfect! Thank you

Debra Dalgleish has some techniques at:

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