Clear row label data in pivot table

S

Shig

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)?
 
R

Roger Govier

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 said:
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
Click to expand...

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

The message was checked by ESET Smart Security.

http://www.eset.com
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Dates In Excel 5
Dealing with a Pivot Table (when I don't want to) 0
Pivot Table - Row Label Combination 0
Pivot Table cell values 1
Pivot Table Counting Text Data 0
Doughnut Chart linked with the slicer in the pivot table 0
Creating a Chart on form from selected data in query. 0
Pivot table put multiple "Values" in one row but I want them in one column. 0

Top