Set CNG cipher algorithm: registry value cipheralgorithm (excel\security\crypto)UserHKCU\software\policies\microsoft\office\16.0\excel\security\crypto

Policy ID: L_SetCNGCipherAlgorithm
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

cipheralgorithm

REG_SZUser

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

Enabled value: Depends on the option value
Element: CNG cipher algorithm:
Value type: REG_SZ
Required: true

Apply with .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

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

; Value names and types follow the ADMX. Replace <enter value> below with your own data
"cipheralgorithm"="<enter value>"

CMD

:: Value names and types follow the ADMX. Replace <enter value> below with your own data

reg add "HKCU\software\policies\microsoft\office\16.0\excel\security\crypto" /v "cipheralgorithm" /t REG_SZ /d "<enter value>" /f

PowerShell

# Value names and types follow the ADMX. Replace <enter value> below with your own data

New-Item -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Force | Out-Null
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\security\crypto' -Name 'cipheralgorithm' -PropertyType String -Value '<enter value>' -Force | Out-Null