Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cannot change data source for copied charts | Charts and Charting in Excel | |||
Change Data Source for Multiple Pivot Tables | Excel Discussion (Misc queries) | |||
Data Source in Pivot Tables | Charts and Charting in Excel | |||
Source Data in Pivot Tables | Excel Worksheet Functions | |||
Pivot Table data source "data source contains no visible tables" | Excel Worksheet Functions |