Ask to update automatic links

This policy setting controls whether Excel 2007 prompts users to update automatic links, or whether the updates occur in the background with no prompt.

If you enable this policy setting, Excel 2007 will prompt users to update automatic links, which enforces the default configuration. In addition, the "Ask to update automatic links" user interface option under Excel Options | Advanced | General is selected, and users cannot deselect it.

If you disable this policy setting, Excel updates automatic links without prompting or informing users, which could compromise the integrity of some of the information in the workbook.

If you do not configure this policy setting, the behavior of Excel 2007 is the same as Enabled; however, users can change this behavior in Excel by configuring the "Ask to update automatic links" user interface option under Excel Options | Advanced | General.

Supported on: At least Windows Vista
Registry HiveHKEY_CURRENT_USER
Registry PathSoftware\Policies\Microsoft\Office\12.0\Excel\Options\BinaryOptions
Value NamefUpdateExt_78_1
Value TypeREG_DWORD
Enabled Value0
Disabled Value1

excel12.admx

Administrative Templates (Computers)

Administrative Templates (Users)