Group Policy SearchGroup Policy Search
English

Set document behavior if file validation fails: registry value openinprotectedview and 1 more (excel\security\filevalidation)UserHKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation

Policy ID
L_SetDocumentBehaviorIfFileValidationFails
Scope
User Configuration
Supported on
At least Windows Server 2008 R2 or Windows 7
Source
Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
Category
Microsoft Excel 2016 › Excel Options › Security › Trust Center › Protected View

Registry

openinprotectedview

REG_DWORDUser
HKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation Current key
Enabled value
Depends on the option value
Element
-
Options
ItemStored value
Block files0
Open in Protected View1
Apply with .reg · CMD · PowerShell
.reg
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\filevalidation]

; Options (use only one)
; Block files
"openinprotectedview"=dword:00000000
; Open in Protected View
"openinprotectedview"=dword:00000001
CMD
:: Options (use only one)

:: Block files
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation" /v "openinprotectedview" /t REG_DWORD /d 0 /f
:: Open in Protected View
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation" /v "openinprotectedview" /t REG_DWORD /d 1 /f
PowerShell
# Common: create the key
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation' -Force | Out-Null

# Options (use only one)
# Block files
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation' -Name 'openinprotectedview' -PropertyType DWord -Value 0 -Force | Out-Null
# Open in Protected View
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation' -Name 'openinprotectedview' -PropertyType DWord -Value 1 -Force | Out-Null

disableeditfrompv

REG_DWORDUser
HKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation Current key
Checked
0
Unchecked
1
Element
Checked: Allow edit. Unchecked: Do not allow edit.
Value type
REG_DWORD
Apply with .reg · CMD · PowerShell
.reg
Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\filevalidation]

; Options (use only one)
; Checked
"disableeditfrompv"=dword:00000000
; Unchecked
"disableeditfrompv"=dword:00000001
CMD
:: Options (use only one)

:: Checked
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation" /v "disableeditfrompv" /t REG_DWORD /d 0 /f
:: Unchecked
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\filevalidation" /v "disableeditfrompv" /t REG_DWORD /d 1 /f
PowerShell
# Common: create the key
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation' -Force | Out-Null

# Options (use only one)
# Checked
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation' -Name 'disableeditfrompv' -PropertyType DWord -Value 0 -Force | Out-Null
# Unchecked
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation' -Name 'disableeditfrompv' -PropertyType DWord -Value 1 -Force | Out-Null