How to Update Link Workbooks in Excel 2007

1. Close out all of the workbooks in the Microsoft Excel 2007 application. Click on the “Microsoft Office” button and then click on the “Open” option.
2. Select the destination workbook that contains all of the links and then click on the “Open” button.
3. Click on the “Update” button from the pop-up dialog box that appears on the screen to automatically update all of the links for the source workbooks.
4. Click on the “Don’t Update” option if you want to only select links to other workbooks, and then click on the “Edit” option from the top toolbar menu.
5. Click on the “Links” option and then select the object you want to update from the “Source” list. Click on the “Update Values” option.