Open in the explorer

Perform file validation on pivot caches

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

Explanation

This policy key configures whether or not pivot caches should go through file validation and get scanned for security problems when documents in Excel 97-2003 format are opened.

If you enable this policy setting, you may select one of these options:

- No file validation: Never perform file validation on pivot caches for all Excel files (not recommended).
- Web and email sources: Perform file validation on pivot caches for documents that come from the web and email, in addition to all documents that trigger pivot caches on load (default).
- Always perform validation: Always perform file validation on pivot caches for all Excel files.

This setting can be overridden by the Object Model property Application.FileValidationPivot.

If you disable or do not configure this policy setting, the "Web and email source" setting will apply.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\filevalidation
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_PerformFileValidationOnPivotCaches
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\security\filevalidation'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
#
# Possible options:
#   No file validation = 0
#   Web and email sources = 1
#   Always perform validation = 2
Set-ItemProperty -Path $k -Name 'pivotoptions' -Value 1 -Type DWord

Disable

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

Revert to "Not configured"

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

Options (1)

LabelControlRegistry valueREG typeConstraints / details
L_PerformFileValidationOnPivotCachesDropIDDrop-down listenumpivotoptionsREG_DWORD
Default choice (UI): #1
LabelValue
No file validationREG_DWORD = 0
Web and email sourcesREG_DWORD = 1
Always perform validationREG_DWORD = 2

Application

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

Official templates downloaded on November 12, 2026.