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.
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. ...
Get Microsoft® Office Excel 2003 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
