Browse » Home
Friday, February 25, 2011
How to Update the Links in Excel 2007
1. Open the Microsoft Excel 2007 spreadsheet file on your computer that you want to update links for.
2. Click on the 'Data' tab and then click on the 'Edit Links' option from the 'Connections' group.
3. Click on the 'Update Values' option and the links will automatically be updated. Click on the 'Close' button.
4. Click on the 'Data' tab and then click on the 'Edit Links' option again. Click on the 'Startup Prompt' option.
5. Click on the box next to the 'Ask to update automatic links' field so that it's selected. Close out of the dialog box, and now you will receive an automatic message that appears every time you open Excel, asking if you want to update your links.