Managing Links

If an Excel workbook includes links to other documents, you can use the Edit Links command (in the Connections group on the Data tab) to summon the dialog box shown in Figure 30-7. The Edit Links dialog box lists all the links in the current file, including links created by formula references to cells in other worksheets.

To update, alter, or sever a link, click the Data tab, and then click Edit Links (in the Connections group).

Figure 30-7. To update, alter, or sever a link, click the Data tab, and then click Edit Links (in the Connections group).

Choosing Automatic or Manual Update

The Automatic and Manual options, near the bottom of the dialog box, control the manner in which your links are updated. If you select Automatic (the only choice ...

Get Microsoft® Office Excel® 2007 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.