Updating Links

Summary: When you establish links between data on a target worksheet and data on a source worksheet, those links are typically updated when you open the target workbook or choose to print the workbook. If you want to manually update the links at some other time, however, you can use the steps in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, Excel 2003, and Excel 2007.)

Normally, if you have linked information in your workbook, the information is updated whenever you open the workbook. There may be times when you need to update the links manually, however. You do this by following these steps:

Display the Edit Links dialog box. (Click here to see a related figure.) (In Excel 2007 click the Office button, then click Prepare | Edit Links to Files. In older versions of Excel choose Links from the Edit menu.)
Select the link you want to update.
Click on Update Now or Update Values (the wording depends on your version of Excel).
Click on OK.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (3101) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Change Formatting Based On Your Data! Conditional formatting provides a way for you to adjust the appearance of your data based on the data itself. Discover how to put this amazingly powerful feature to work for you, today. This comprehensive volume is available in two editions.

Check out Excel Conditional Formatting today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Updating Links