Copy a worksheet from one file to another
 

I have 5 identical Excel workbooks.

I created a worksheet on one of the files, which consists totally of
references to various cells in the existing sheets.

I want to copy this sheet to the other 4 Excel workbooks, however the
references point to the original file and its cells, not the one I am
adding it to.

How is this possible?

Copy a worksheet from one file to another
 

Its really trying to be helpful...
To fix it:
Copy it to one of the other workbooks, with the new sheet the active sheet,
click Edit - Replace. In the Find box, type [old workbook name] - the way it
appears in the cell references and leave the replace box empty.
Click Replace All and they should now work the way you wanted...


" wrote:

I have 5 identical Excel workbooks.

I created a worksheet on one of the files, which consists totally of
references to various cells in the existing sheets.

I want to copy this sheet to the other 4 Excel workbooks, however the
references point to the original file and its cells, not the one I am
adding it to.

How is this possible?