Ask to update automatic links

Supported on: At least Windows Server 2008 R2 or Windows 7

Registry

HKCU software\policies\microsoft\office\16.0\excel\options\binaryoptions

Value name: fupdateext_78_1

Enabled: fupdateext_78_1 = 0

Disabled: fupdateext_78_1 = 1

Description

This policy setting controls whether Excel prompts users to update automatic links, or whether the updates occur in the background with no prompt. If you enable or do not configure this policy setting, Excel will prompt users to update automatic links. In addition, the "Ask to update automatic links" user interface option under File tab | Advanced | General is selected. 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.