| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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)? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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)? . |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 2007 pivot table display data in row label | Excel Discussion (Misc queries) | |||
| How to clear data in pivot table? | Excel Worksheet Functions | |||
| Pivot Table Clear All Filters | Excel Discussion (Misc queries) | |||
| Pivot Table Clear All Fiels | Excel Discussion (Misc queries) | |||
| need to clear data references in pivot table report | Charts and Charting in Excel | |||
Linear Mode
