Prev: Saving from 2007 to 2003 - 2003 won't open the file
Next: vlookup with if statement?
From: Shig on 2 Feb 2010 11:13
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)?
From: Jim Thomlinson on 2 Feb 2010 11:56
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)?
> .
>
From: Roger Govier on 2 Feb 2010 12:08
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" <sodani(a)gmail.com> wrote in message
news:5bdde283-2d39-46d8-923a-2f86f2b8c9c5(a)d30g2000vbl.googlegroups.com...
> 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



 | 
Pages: 1
Prev: Saving from 2007 to 2003 - 2003 won't open the file
Next: vlookup with if statement?