Excel 2010 Bible

Part IV: Using Advanced Excel Features

594

FIGURE 27.3

The Edit Links dialog box.

Changing the startup prompt

When you open a workbook that contains one or more external reference formulas, Excel, by

default, displays the dialog box (shown in Figure 27.2) that asks how you want to handle the

links. You can eliminate this prompt by changing a setting in the Startup Prompt dialog box

(see Figure 27.4).

To display the Startup Prompt dialog box, choose File ➪ Info ➪ Related Documents ➪ Edit Links

to Files, which displays the Edit Links dialog box (refer to Figure 27.3). There, click the Startup

Prompt button and then select the option that describes how you want to handle the links.

FIGURE 27.4

Use the Startup Prompt dialog box to specify how Excel handles links when the workbook is opened.

Updating links

If you want to ensure that your link formulas have the latest values from their source workbooks,

you can force an update. For example, say that you just discovered that someone made changes to

the source workbook and saved the latest version to your network server. In such a case, you may

want to update the links to display the current data.

To update linked formulas with their current value, open the Edit Links dialog box (choose File ➪

Info ➪ Related Documents ➪ Edit Links to Files), choose the appropriate source workbook in the