Copy a sheet with charts to another workbook

[leon]

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.

 

[Jon Peltier]

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

 

[leon]

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
_______





Works like a dream Jon Thanks