Alert before overwriting cells
Jump to overview

Policy overview

Key metadata and intent for this policy.

User
Category
Microsoft Excel 2016 > Excel Options > Advanced
Supported on
Windows7

This policy setting sets the "Alert before overwriting cells" option found under File tab | Options | Advanced | Editing Options. If you enable or do not configure this policy setting, Excel will give a warning if cells are about to be overwritten. This is the default behavior. If you disable this policy setting, Excel will suppress the warning that cells are about to be overwritten.

Internal name
L_Alertbeforeoverwritingcells
Policy ID
36ecda4a332f
Elements
0

Registry values

How enabled and disabled states update the registry.

ScopeRegistry locationTypeEnabled valueDisabled valueCopy
User
Path
software\policies\microsoft\office\16.0\excel\options\binaryoptions
Value name
fnodragwarning_76_1
REG_DWORD
HKCU
0
HKCU
1
Registry location
Type REG_DWORD · User
Path
software\policies\microsoft\office\16.0\excel\options\binaryoptions
Value name
fnodragwarning_76_1
Hive
HKCU
Enabled value
0
Disabled value
1

Policy elements

Inputs and configuration options exposed by this policy.

This policy has no additional user input fields.