Copy Worksheet to New Workbook

[Unique_Identifier]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel I have a worksheet I'd like to simply copy to several other workbooks. The formulae in it would refer to other sheets within the workbook it's being copied to (all the workbooks contain sheets with the same names). Every time I copy the sheets, the formulae all change to refer back to the original workbook. How can I copy the sheet without having to go through and tweak each formula to refer to the right place?

 

[Bob Greenblatt]

Version: 2008 Operating System: Mac OS X 10.6 (Snow Leopard) Processor: Intel
I have a worksheet I'd like to simply copy to several other workbooks. The
formulae in it would refer to other sheets within the workbook it's being
copied to (all the workbooks contain sheets with the same names). Every time
I copy the sheets, the formulae all change to refer back to the original
workbook. How can I copy the sheet without having to go through and tweak
each formula to refer to the right place?

Do what you are doing, and then on the new workbook, select Edit-Links.
Change the link to the original workbook to the current workbook.

 

[Unique_Identifier]

Do what you are doing, and then on the new workbook, select Edit-Links. Change the link to the original workbook to the current workbook.

>
> --

This works very well for the formulae concerned, thanks very much, but I forgot to mention that most of the sheet is made up of charts, which, if they did not refer to cells on the same sheet, still refer to the original workbook. Any other suggestions?

 

[Bob Greenblatt]

This works very well for the formulae concerned, thanks very much, but I
forgot to mention that most of the sheet is made up of charts, which, if they
did not refer to cells on the same sheet, still refer to the original
workbook. Any other suggestions?

It ought to work for charts also. If the chart formulas do not show up as a
link, this is a bug. I do not have time to check it out now, however. I¹ll
look into it in a day or so.