Tips.Net > ExcelTips Home > Workbooks > Linking Workbooks > Updating Links
Updating Links
Summary: Excel allows you to link to information stored in other workbooks. If you want to update the information represented by these links, you’ll want to become familiar with the Edit Links dialog box, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)
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:
- Choose Links from the Edit menu. Excel displays the Edit Links dialog box.
- Select the link you want to update.
- Click on Update Now or Update Values (the wording depends on your version of Excel).
Tip #3101 applies to Microsoft Excel versions: 97 2000 2002 2003
Make Home Buying Less Stressful! Why face the annual problems associated with Christmas debt? Learn how to avoid that debt and conquer your financial challenges.
Check out Buying a Home Checklist today!
Macros Rock!
Want to make Excel do even more? The way is easy when you know how to use macros. This great e-book makes it easy. (more information...)
Helpful Links
Ask an Excel Question
Make a Comment
ExcelTips FAQ
ExcelTips Premium
Beauty Tips
Bugs and Pests Tips
Car Tips
Cleaning Tips
College Tips
Cooking Tips
Excel2007 Tips
ExcelTips
Family Tips
Gardening Tips
Health Tips
Home Tips
Money Tips
Organizing Tips
Pet Tips
Word2007 Tips
WordTips
Advertise on the
ExcelTips Site