External Content

The External Content category controls how Excel updates content external to a workbook. There are two types of external content regulated by the External Content category settings. The first is content from databases and other non-Excel sources, which are usually accessed through PivotTables, ListObjects, and QueryTables. The second are external Excel workbooks, which are most commonly linked to from worksheet formulas. The two types of content are controlled by separate groups of settings under the External Content category. These settings are shown in Figure 22-11.

Trusi Cerner TlJlj

Trusted Publisher!

Security settings for Data Connections

Trusted Locations

O Enable all Data Connections (not

Add-ins

recommended1) ' •j Prompt user abairt Data Connections

ActiveX Settings

O .Disable all Data Connections

Macro Settings

Security settings for Workbook Links

Message Bar

O Enable automatic update for all Workbook

External Conttnt

Links (not recommended J © Prompt user on automatic update for

Workbook Links 1. ) Disable automatic update of Woikbook Links

Privacy Options

Figure 22-11

□ Security settings for Data Connections — These options apply to external connections to nonExcel data sources.

□ Enable all Data Connections (not recommended) — If this option is selected, you will not receive any warning when opening a workbook that contains connections to external data. All external data connection features, including automatic data refreshing of data, will be enabled.

□ Prompt user about Data Connections — If this option is selected, you will receive a Message Bar notification when opening a workbook that contains connections to external data. All external data connection features will be disabled until you click the Options button on the Message Bar and choose to enable the connections. This is the default option for this section.

□ Disable all Data Connections — If this option is selected, all external data connection features will be disabled automatically, with no Message Bar notification.

□ Security settings for Workbook Links — These options apply to links to other Excel workbooks.

□ Enable automatic update for all Workbook Links (not recommended) — If this option is selected, all links to external Excel workbooks will be updated automatically, and you will not receive any Message Bar notification.

□ Prompt user on automatic update for Workbook Links — If this option is selected, you will receive a Message Bar notification when opening a workbook that contains links to external workbooks. The links will not be updated unless you click the Options button on the Message Bar and choose to enable the links.

□ Disable automatic update of Workbook Links — If this option is selected, all links to external Excel workbooks will be disabled, with no Message Bar notification given.

Was this article helpful?

0 0

Post a comment