Excel 97-2003 workbooks and templates: registry value xl97workbooksandtemplatesUserHKCU\software\policies\microsoft\office\16.0\excel\security\fileblock
- Policy ID
- L_Excel972003WorkbooksAndTemplates
- 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 › File Block Settings
Registry
xl97workbooksandtemplates
REG_DWORDUser- Enabled value
- Depends on the option value
- Element
- File block setting:
| Item | Stored value |
|---|---|
| Do not block | 0 |
| Save blocked | 1 |
| Open/Save blocked, use open policy | 2 |
| Block | 3 |
| Open in Protected View | 4 |
| Allow editing and open in Protected View | 5 |
Apply with .reg · CMD · PowerShell
.reg
Windows Registry Editor Version 5.00 [HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\fileblock] ; Options (use only one) ; Do not block "xl97workbooksandtemplates"=dword:00000000 ; Save blocked "xl97workbooksandtemplates"=dword:00000001 ; Open/Save blocked, use open policy "xl97workbooksandtemplates"=dword:00000002 ; Block "xl97workbooksandtemplates"=dword:00000003 ; Open in Protected View "xl97workbooksandtemplates"=dword:00000004 ; Allow editing and open in Protected View "xl97workbooksandtemplates"=dword:00000005
CMD
:: Options (use only one) :: Do not block reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl97workbooksandtemplates" /t REG_DWORD /d 0 /f :: Save blocked reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl97workbooksandtemplates" /t REG_DWORD /d 1 /f :: Open/Save blocked, use open policy reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl97workbooksandtemplates" /t REG_DWORD /d 2 /f :: Block reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl97workbooksandtemplates" /t REG_DWORD /d 3 /f :: Open in Protected View reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl97workbooksandtemplates" /t REG_DWORD /d 4 /f :: Allow editing and open in Protected View reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\fileblock" /v "xl97workbooksandtemplates" /t REG_DWORD /d 5 /f
PowerShell
# Common: create the key New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Force | Out-Null # Options (use only one) # Do not block New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl97workbooksandtemplates' -PropertyType DWord -Value 0 -Force | Out-Null # Save blocked New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl97workbooksandtemplates' -PropertyType DWord -Value 1 -Force | Out-Null # Open/Save blocked, use open policy New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl97workbooksandtemplates' -PropertyType DWord -Value 2 -Force | Out-Null # Block New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl97workbooksandtemplates' -PropertyType DWord -Value 3 -Force | Out-Null # Open in Protected View New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl97workbooksandtemplates' -PropertyType DWord -Value 4 -Force | Out-Null # Allow editing and open in Protected View New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\fileblock' -Name 'xl97workbooksandtemplates' -PropertyType DWord -Value 5 -Force | Out-Null