Home |
Search |
Today's Posts |
#1
|
|||
|
|||
"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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I show summary totals from a pivot table on a bar chart | Charts and Charting in Excel | |||
How do I create a pivot table if the pivot table icon or menu ite. | Charts and Charting in Excel | |||
Jon Peltier - Pivot Table Result for yesterday's "Complex Chart" Question | Charts and Charting in Excel | |||
create space in line chart between points, linked to pivot table | Charts and Charting in Excel | |||
pivot table multi line chart | Charts and Charting in Excel |