O'Reilly logo

Microsoft® Office Excel 2003 Inside Out by Mark Dodge, Craig Stinson

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Managing Links

If an Excel workbook includes links to other documents, you can choose Edit, Links to summon the dialog box shown in Figure 21-8. The Edit Links dialog box lists all links in the current file, including links created by formula references to cells in other worksheets.

To update, alter, or sever a link, choose Edit, Links.

Figure 21-8. To update, alter, or sever a link, choose Edit, Links.

Choosing Automatic or Manual Update

The Automatic and Manual option buttons, near the bottom of the dialog box, control the manner in which your links are updated. If you choose Automatic (the only choice available for links with other Excel documents), your link is updated whenever the source changes. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required