Tips, Tricks, and Answers

The following articles are available. Click the article's title (shown in bold) to see the associated article.

Don’t Update Links to Other Programs Excel allows you to link to information stored in or created by other programs. Normally the links are updated automatically. This tip explains how to turn off the automatic link updating without modifying the individual link settings. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Easily Changing Links Using Excel's ADDRESS and INDIRECT features to update links in a workbook. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Getting Rid of Workbook Links There are two types of links in Excel: workbook links and hyperlinks. Getting rid of the first can be tricky, at times. This tip explains the different ways you can get rid of them. Microsoft Excel versions: 97 | 2000 | 2002 | 2003 | 2007

Uncovering and Removing Links Data can be linked into a workbook from a variety of external sources. If you get a workbook from a co-worker or friend, those links may not work any more. If you want to remove the links, tracking them down can be challenging. This tip explains several of the places in which links can be located and how you can remove them. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Updating Links 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. Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Helpful Links

Ask an Excel Question
Make a Comment

Tips.Net Home
Vital News Home

ExcelTips FAQ
ExcelTips Premium

Learn Access Now

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

 

RSS Feeds

 Daily Nuggets (an ExcelTip every day)

 Allen Wyatt's ExcelTips (the weekly classic)