Excel 2010 Bible

Chapter 27: Linking and Consolidating Worksheets

593

What if you choose to update the links, but the source workbook is no longer available? If Excel

can’t locate a source workbook that’s referred to in a link formula, it displays its Edit Links dialog

box, shown in Figure 27.3. Click the Change Source button to specify a different workbook, or

click the Break Link to destroy the link.

Note
You can also access the Edit Links dialog box by choosing File ➪ Info ➪ Related Documents ➪ Edit Links to
Files. The dialog box that appears lists all source workbooks, plus other types of links to other documents. n

FIGURE 27.2

Excel displays this dialog box when you open a workbook that contains links to other files.

Excel 2010 features a new security feature. The first time you open a workbook that contains links to

other files, you see a security warning below the Ribbon. The links will not be updated unless you click

the Enable Content button.

However, Excel remembers that you’ve deemed the workbook safe, so you won’t see that Security

Warning again. If you would like to disable these Security Warnings, use the External Content tab of the

Trust Center dialog box and change the option for Security Settings for Workbook Links. To display this

dialog box, choose File ➪ Options. Then click the Trust Center tab, and click the Trust Center Settings

button.

Security Warning for Links