How Do I Update Links in Excel?

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Press "Enable Content" to allow working links to update.
Image Credit: Image courtesy of Microsoft

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.

Advertisement

Step 1

Press "Edit Links."
Image Credit: Image courtesy of Microsoft

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

Advertisement

Video of the Day

Step 2

Change the source.
Image Credit: Image courtesy of Microsoft

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

Advertisement

Step 3

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

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.

Advertisement

Step 4

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

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.

Advertisement

Advertisement

Step 5

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

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.

Video of the Day

Advertisement

Advertisement

references & resources