Specify CNG hash algorithm: registry value hashalgorithm (excel\security\crypto)UserHKCU\software\policies\microsoft\office\16.0\excel\security\crypto

Policy ID: L_SpecifyCNGHashAlgorithm
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 › Cryptography

Registry

hashalgorithm

REG_SZUser

HKCU\software\policies\microsoft\office\16.0\excel\security\crypto Current key

Enabled value: Depends on the option value
Element: -

Options
Item	Stored value
SHA1	SHA1
SHA256	SHA256
SHA384	SHA384
SHA512	SHA512

Apply with .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

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

; Options (use only one)
; SHA1
"hashalgorithm"="SHA1"
; SHA256
"hashalgorithm"="SHA256"
; SHA384
"hashalgorithm"="SHA384"
; SHA512
"hashalgorithm"="SHA512"

CMD

:: Options (use only one)

:: SHA1
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\crypto" /v "hashalgorithm" /t REG_SZ /d "SHA1" /f
:: SHA256
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\crypto" /v "hashalgorithm" /t REG_SZ /d "SHA256" /f
:: SHA384
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\crypto" /v "hashalgorithm" /t REG_SZ /d "SHA384" /f
:: SHA512
reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\crypto" /v "hashalgorithm" /t REG_SZ /d "SHA512" /f

PowerShell

# Common: create the key
New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Force | Out-Null

# Options (use only one)
# SHA1
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Name 'hashalgorithm' -PropertyType String -Value 'SHA1' -Force | Out-Null
# SHA256
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Name 'hashalgorithm' -PropertyType String -Value 'SHA256' -Force | Out-Null
# SHA384
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Name 'hashalgorithm' -PropertyType String -Value 'SHA384' -Force | Out-Null
# SHA512
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Name 'hashalgorithm' -PropertyType String -Value 'SHA512' -Force | Out-Null