Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy a sheet with charts to another workbook
Is there some way in which I can copy a sheet with charts in it to another
workbook and have the charts refer to the workbook I am copying to. The two workbooks are identical in every way except for the values within individual cells. |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy a sheet with charts to another workbook
If the data is on the sheet being copied, the charts should keep their links
without any problem. If the data is on other sheets, you should copy these sheets too, copy the data and paste it into the copied sheets. Another alternative if everything is the same, including sheet names is to copy just the sheet with charts, then go to Edit menu Links, select the link to the other workbook, click Change Links, and browse to the active workbook. This should link to the active workbook instead of the original workbook. (I haven't done this often enough or recently enough to know for sure how it works.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "leon" wrote in message ... Is there some way in which I can copy a sheet with charts in it to another workbook and have the charts refer to the workbook I am copying to. The two workbooks are identical in every way except for the values within individual cells. |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Copy a sheet with charts to another workbook
"Jon Peltier" wrote: If the data is on the sheet being copied, the charts should keep their links without any problem. If the data is on other sheets, you should copy these sheets too, copy the data and paste it into the copied sheets. Another alternative if everything is the same, including sheet names is to copy just the sheet with charts, then go to Edit menu Links, select the link to the other workbook, click Change Links, and browse to the active workbook. This should link to the active workbook instead of the original workbook. (I haven't done this often enough or recently enough to know for sure how it works.) - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "leon" wrote in message ... Is there some way in which I can copy a sheet with charts in it to another workbook and have the charts refer to the workbook I am copying to. The two workbooks are identical in every way except for the values within individual cells. Works like a dream Jon Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Copy charts from 1 workbook to another | Charts and Charting in Excel | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) | |||
Copy a Sheet from one Workbook to another | Excel Discussion (Misc queries) |