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

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

Debra Dalgleish has some techniques at:

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



AyPee wrote:

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

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

"Dave Peterson" wrote:

Debra Dalgleish has some techniques at:

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



AyPee wrote:

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

Perfect! Thank you

"Dave Peterson" wrote:

Debra Dalgleish has some techniques at:

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



AyPee wrote:

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