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.

image from book
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 available for links with other Excel documents), your link is updated whenever the source changes. This automatic updating occurs instantaneously with some source applications and takes a while longer with others. Theoretically, you don't need to concern yourself with refreshing the link; Windows performs that duty for you. If you find that the updating occurs more frequently than you want it to (or if the process intrudes on your concentration in any way), you might want to switch from Automatic to Manual. With updating set to Manual, you can force an update by returning to the Edit Links dialog box and clicking Update Values.

Fixing Broken Links

If Excel tries to update a link and can't find the source file, it presents an error message. This kind of problem occurs most commonly when a file to which you've defined a link is renamed, relocated, or removed. If the source has been renamed or moved and you know its current identity and whereabouts, you can often fix the problem by editing the link formula. Alternatively, revisit the Edit Links dialog box (click Edit Links on the Data tab), and then click the Change Source button. Unfortunately, the Change Links dialog box does not include a file browser, so you'll need to type or edit the file specification manually:

image from book



Microsoft Office Excel 2007 Inside Out
MicrosoftВ® Office ExcelВ® 2007 Inside Out (Inside Out (Microsoft))
ISBN: 073562321X
EAN: 2147483647
Year: 2004
Pages: 260

flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net