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.
Video of the Day
Open the destination workbook, which contains the non-working links, and click "Edit Links" in the Connections section of the Data tab.
Select the source of the broken link and press "Change Source."
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.
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.
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.