If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
how to change old data source reference from copied pivot tables
Hi All,
I wanted to change the old datasource reference from my copied sheets having pivot tables and charts. I copied the sheets from other workbook. how can i resolve this issue, i am not geting any way to overcome this issue. If any body has any solution, kindly let me know. I am using excel 2007. Thanks in Advance |
#2
|
|||
|
|||
how to change old data source reference from copied pivot tables
Hi,
Go to the pivot table, at the top centre of the screen you will see Pivottable tools click on that, then go to data, 5th tab from the left and click on chane data Source, same procedure with the charts If this was helpful please click yes, thanks "arun" wrote: Hi All, I wanted to change the old datasource reference from my copied sheets having pivot tables and charts. I copied the sheets from other workbook. how can i resolve this issue, i am not geting any way to overcome this issue. If any body has any solution, kindly let me know. I am using excel 2007. Thanks in Advance |
Thread Tools | |
Display Modes | |
|
|