Clear row label data in pivot table
 

I'm using Excel 2007 and I replaced all the data in my datasheet
except for the headers because I wanted fresh data but didn't want to
have to create all new pivot tables. Now, when I go to the pivot table
and select row data, the new values are there, but the old values are
also there. Is there a way for me to remove the old values (which are
no longer in the datasheet)?

Clear row label data in pivot table
 

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

Jim Thomlinson


"Shig" wrote:

I'm using Excel 2007 and I replaced all the data in my datasheet
except for the headers because I wanted fresh data but didn't want to
have to create all new pivot tables. Now, when I go to the pivot table
and select row data, the new values are there, but the old values are
also there. Is there a way for me to remove the old values (which are
no longer in the datasheet)?
.

Clear row label data in pivot table
 

Hi

Drag the Row field back to the Filed List area.
Refresh the PT
Drag the Field back to the Row area

--
Regards
Roger Govier

"Shig" wrote in message
...
I'm using Excel 2007 and I replaced all the data in my datasheet
except for the headers because I wanted fresh data but didn't want to
have to create all new pivot tables. Now, when I go to the pivot table
and select row data, the new values are there, but the old values are
also there. Is there a way for me to remove the old values (which are
no longer in the datasheet)?

__________ Information from ESET Smart Security, version of virus
signature database 4828 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com




__________ Information from ESET Smart Security, version of virus signature database 4828 (20100202) __________

The message was checked by ESET Smart Security.

http://www.eset.com