OLAP PivotTable User Defined Function (UDF) security setting: registry value olapudfsecurityUserHKCU\software\policies\microsoft\office\16.0\excel\options

Policy ID: L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting
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 › Miscellaneous

Registry

olapudfsecurity

REG_DWORDUser

HKCU\software\policies\microsoft\office\16.0\excel\options Current key

Enabled value: Depends on the option value
Element: OLAP PivotTable User Defined Function (UDF) security setting

Options
Item	Stored value
Allow ALL UDFs	1
Allow safe UDFs only	2
Allow NO UDFs	3

Apply with .reg · CMD · PowerShell

.reg

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options]

; Options (use only one)
; Allow ALL UDFs
"olapudfsecurity"=dword:00000001
; Allow safe UDFs only
"olapudfsecurity"=dword:00000002
; Allow NO UDFs
"olapudfsecurity"=dword:00000003

CMD

:: Options (use only one)

:: Allow ALL UDFs
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "olapudfsecurity" /t REG_DWORD /d 1 /f
:: Allow safe UDFs only
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "olapudfsecurity" /t REG_DWORD /d 2 /f
:: Allow NO UDFs
reg add "HKCU\software\policies\microsoft\office\16.0\excel\options" /v "olapudfsecurity" /t REG_DWORD /d 3 /f

PowerShell

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

# Options (use only one)
# Allow ALL UDFs
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'olapudfsecurity' -PropertyType DWord -Value 1 -Force | Out-Null
# Allow safe UDFs only
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'olapudfsecurity' -PropertyType DWord -Value 2 -Force | Out-Null
# Allow NO UDFs
New-ItemProperty -Path 'HKCU:\software\policies\microsoft\office\16.0\excel\options' -Name 'olapudfsecurity' -PropertyType DWord -Value 3 -Force | Out-Null