Open in the explorer

OLAP PivotTable User Defined Function (UDF) security setting

Type
User
GPO path
User Configuration › Policies › Administrative Templates › Microsoft Excel 2016 › Miscellaneous
Supported on
At least Windows Server 2008 R2 or Windows 7
ADMX file
excel16.admx
Internal name
excel16/L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting

Explanation

PivotTable reports can contain OLAP queries with references to User Defined Functions (UDFs). UDFs can be compiled executables, therefore posing a potential security threat. With this setting you can either (1) allow all UDFs in OLAP queries to execute with no IObjectSafety check, (2) allow only UDFs where the developer has used IObjectSafety to mark the UDF as a safe executable, or (3) disable all UDFs from executing in OLAP queries. The effect of setting this key is for Excel to pass the selected value to the OLAP provider.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options
Value name
not defined in the ADMX

Enable / disable values: not defined in the ADMX (see the options below).

PowerShell

PowerShell commands that write to the registry what the policy would write. Values in angle brackets (<…>) must be replaced.

Writing directly to the registry bypasses Group Policy: if a GPO manages this value, it will be rewritten at the next gpupdate; otherwise the value stays in place (the "tattooing" effect). Prefer a GPO or, locally, LGPO.exe. Run PowerShell as administrator for HKLM. Some policies need a restart or gpupdate /force.

Enable

# Enable: excel16/L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# OLAP PivotTable User Defined Function (UDF) security setting
# Possible options:
#   Allow ALL UDFs = 1
#   Allow safe UDFs only = 2
#   Allow NO UDFs = 3
Set-ItemProperty -Path $k -Name 'olapudfsecurity' -Value 2 -Type DWord

Disable

# Disable: excel16/L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting
# No value is written in the "Disabled" state (nothing defined in the ADMX)

Revert to "Not configured"

# Revert to "Not configured": excel16/L_OLAPPivotTableUserDefinedFunctionUDFsecuritysetting
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
Remove-ItemProperty -Path $k -Name 'olapudfsecurity' -ErrorAction SilentlyContinue

Options (1)

LabelControlRegistry valueREG typeConstraints / details
OLAP PivotTable User Defined Function (UDF) security settingL_olappivottableuserdefinedfunctionudfsecuritysetting171Drop-down listenumolapudfsecurityREG_DWORD
Default choice (UI): #1
LabelValue
Allow ALL UDFsREG_DWORD = 1
Allow safe UDFs onlyREG_DWORD = 2
Allow NO UDFsREG_DWORD = 3

Application

Microsoft 365 Apps / Office (Microsoft) — November 2026 templates

Official templates downloaded on November 12, 2026.