Hi

I have a pivot table that is showing data in the row field that is not
in the current range of data. i do not want this row name to be
displayed at all.
This name did appear in the data range previously but was overwritten
by new data.
How do I ensure this name does not appear in the pivot table?
I have refreshed the data and double checked that the name is not in
the current data range.

Many thanks

W

If you're talking about the Pivot Table DropDown lists still showing items
that aren't in the source data any more, see Debra Dalgleish's coverage of
the topic:
http://www.contextures.com/xlPivot04.html

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

wrote in message
oups.com...
Hi

I have a pivot table that is showing data in the row field that is not
in the current range of data. i do not want this row name to be
displayed at all.
This name did appear in the data range previously but was overwritten
by new data.
How do I ensure this name does not appear in the pivot table?
I have refreshed the data and double checked that the name is not in
the current data range.

Many thanks

W

Hi
Many thanks it worked, I ran the program

Cheers

W





On 4 Nov, 18:49, "Ron Coderre"
wrote:
If you're talking about the Pivot Table DropDown lists still showing items
that aren't in the source data any more, see Debra Dalgleish's coverage of
the topic:http://www.contextures.com/xlPivot04.html

Does that help?
--------------------------

Regards,

Ron (XL2003, Win XP)
Microsoft MVP (Excel)

wrote in message

oups.com...



Hi

I have a pivot table that is showing data in the row field that is not
in the current range of data. i do not want this row name to be
displayed at all.
This name did appear in the data range previously but was overwritten
by new data.
How do I ensure this name does not appear in the pivot table?
I have refreshed the data and double checked that the name is not in
the current data range.

Many thanks

W- Hide quoted text -

- Show quoted text -