![]() |
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? |
All times are GMT +1. The time now is 07:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com