Excel should allow purging since-deleted PivotTable field values.

[Guest]

There should be an option in Excel for Pivot tables that allows a complete
purging of all legacy data from data that has since been deleted. I use
pivot Tables on a large set of data each month, with changing record numbers.
I would like to drill down to the record number, but because of the record
numbers that were in it in previous months, there are too many values in the
field to allow that.

I know that this can be fixed by dragging the column off of the pivot's
source data, refreshing the pivot, replacing the column and refreshing again,
but there should be a direct way to do this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click "I Agree" in the message pane.

http://www.microsoft.com/office/com...3-c18c8bb41270&dg=microsoft.public.excel.misc

 

[Paul Lautman]

There should be an option in Excel for Pivot tables that allows a
complete purging of all legacy data from data that has since been
deleted. I use pivot Tables on a large set of data each month, with
changing record numbers. I would like to drill down to the record
number, but because of the record numbers that were in it in previous
months, there are too many values in the field to allow that.

I know that this can be fixed by dragging the column off of the
pivot's source data, refreshing the pivot, replacing the column and
refreshing again, but there should be a direct way to do this.

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click
the "I Agree" button in the message pane. If you do not see the
button, follow this link to open the suggestion in the Microsoft
Web-based Newsreader and then click "I Agree" in the message pane.

http://www.microsoft.com/office/com...3-c18c8bb41270&dg=microsoft.public.excel.misc

See http://www.contextures.com/xlPivot04.html
run the macro once and the table will remember the setting and all
subsequent redundant data will automatically be removed.