How Do I Update Links in Excel?

Ordinarily, Excel 2010 and 2013 prompt you to update links between workbooks every time you open a file that contains links. The first time you open a workbook, you might need to click "Enable Content" in the security warning, but thereafter the process works automatically. If you've moved or renamed your source workbook, however, you need to update the link manually by directing Excel to the source's new location.

...
Press "Enable Content" to allow working links to update.
credit: Image courtesy of Microsoft

Step

Open the destination workbook, which contains the non-working links, and click "Edit Links" in the Connections section of the Data tab.

...
Press "Edit Links."
credit: Image courtesy of Microsoft
...
Change the source.
credit: Image courtesy of Microsoft

Step

Select the source of the broken link and press "Change Source."

...
Locate the source workbook.
credit: Image courtesy of Microsoft

Step

Browse to the source workbook's current location, choose it and press "OK." Provided you pick the correct workbook, the source listed in the Edit Links window will read "OK" in the Status column, and the data in all linked cells will update.

...
Change startup prompt settings.
credit: Image courtesy of Microsoft

Step

Press "Startup Prompt" if you want to set Excel to always update or never update working links when you open the current workbook. This setting does not automatically fix broken links -- it only updates links with an "OK" status. The default option, "Let users choose..." uses the current user's setting, which by default displays an update prompt each time you open the workbook.

...
Verify and refresh links.
credit: Image courtesy of Microsoft

Step

Close all open dialog boxes and select a linked cell to verify that its formula points to the updated source workbook. If you need to manually update the data in linked cells again while the book is open, press "Refresh All" on the Data tab.