When you copy a file in Excel, the links to other files in the workbook are not updated. This can cause problems if the location of the linked file has changed since the original file was created. To update the links, follow these steps:
In the Change Link dialog box, do one of the following:
To update a link to another workbook:
(Optional): If you want to change only some of the links in a workbook, select the specific sheets that contain links that you want to update.
(Optional): If you want to change all of the links in a workbook, select all of the sheets by clicking the tab for each sheet at the bottom of the dialog box (for example, Sheet1, Sheet2). To quickly select all sheets, press Ctrl+A. You can also click (Select All). If you do not want to update all of your links, clear any sheets that you do not want to update.