| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change my data or add extra rows in a Pivot Table for Ex.
A more fundamental issue is identifying and getting back to the data source
in a pivot table in 2007. Sometimes it is necessary to add new columns or rows of data which is to be included in the pivot table. In 2003 you can backpedal by right clicking on any pivot table cell and then going back through the Wizard to locate the data source. Then I make my changes to the data source parameters and refresh the pivot table. I cannot find a method to achieve this within 2007. In order to achieve the same result I have to blow away the current pivot table and restart the process. There must be a way but I can not see it. Can you get me an answer? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Too Many rows of data for a pivot table | Excel Discussion (Misc queries) | |||
| Why does same data value appear twice in rows of a Pivot Table | Excel Discussion (Misc queries) | |||
| can i change pivot table to change data | Excel Discussion (Misc queries) | |||
| How to pull extra info into Pivot table report | Excel Worksheet Functions | |||
| How do I change order of rows in pivot table? | Excel Discussion (Misc queries) | |||
Linear Mode
