Excel-how to link source workbook to copy of destination workbook

[D Lynn]

I have two source workbooks that are linked to a destination workbook. I
want to make a copy of the destination workbook and retain the links to the
two source workbooks. Then I want to change the name of the new destination
workbook and retain the links to the two source workbooks.

Is this possible?

 

[Spiky]

I have two source workbooks that are linked to a destination workbook. I
want to make a copy of the destination workbook and retain the links to the
two source workbooks. Then I want to change the name of the new destination
workbook and retain the links to the two source workbooks.

Is this possible?

Should work. Just copy/rename in Windows Explorer. Or do a Save As in
Excel.