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:

1. Open the workbook that contains the broken link.
2. Click Data on the ribbon, and then click Edit Links.
3. In the Edit Links dialog box, click Change Source.

4. In the Change Link dialog box, do one of the following:

   • To update a link to another workbook:

     1. (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.

     2. (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.

Update links automatically when opening files

• If your linked files are stored on your computer or network drive, and you know that they will never move or be renamed, you can have Excel automatically update links when files are opened by doing either of the following:

1. Click (Select All), and then click (Update Values Automatically When Opened). This option updates only those cells whose values have changed since they were last saved.






                         ; Click (Select All), and then click (Update Values Automatically When Opened)

Or

2) Click (Select All), and then click (Update Links Automatically When Opened). This option updates both cells whose values have changed and those whose formulas reference other cells that have changed.Click (Select All), and then click (Update Links Automatically When Opened)