Pivot Tables - Deleting Old Data
Solved
fleur 99
-
Margot -
Margot -
Good evening,
I can't seem to delete the old data in the filter lists and row labels of my pivot tables. I'm not sure if it's possible since I haven't found the information.
I'm using Excel (2007) with a data source sheet and several sheets with pivot tables to analyze my data.
I've updated the header row of my source sheet and also deleted some data from the source.
I have the same problem if I want to reuse my pivot table by copying it for another analysis or another file.
How can I delete this old data?
Thank you for your help.
Configuration: Windows 7 / Chrome 31.0.1650.57
I can't seem to delete the old data in the filter lists and row labels of my pivot tables. I'm not sure if it's possible since I haven't found the information.
I'm using Excel (2007) with a data source sheet and several sheets with pivot tables to analyze my data.
I've updated the header row of my source sheet and also deleted some data from the source.
I have the same problem if I want to reuse my pivot table by copying it for another analysis or another file.
How can I delete this old data?
Thank you for your help.
Configuration: Windows 7 / Chrome 31.0.1650.57
6 réponses
1
Right-click on any cell in the pivot table.
2
Click on "PivotTable Options" in the dropdown menu. A small window appears.
3
Select the "Data" tab at the top of the new window.
4
Under "keep deleted items from the data source" and "number of items to retain per field," choose NONE
click OK and refresh the table.
Right-click on any cell in the pivot table.
2
Click on "PivotTable Options" in the dropdown menu. A small window appears.
3
Select the "Data" tab at the top of the new window.
4
Under "keep deleted items from the data source" and "number of items to retain per field," choose NONE
click OK and refresh the table.
Cool
Great! Your method went down a treat. Thanks a lot!!!
Eric
Since the time I’ve been looking for this... THANK YOU
