Open in the explorer

Set maximum number of trusted documents

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

Explanation

This policy setting allows you to specify the maximum number of trust records for trusted documents that can be stored in the registry before the purge task runs. The purge task reduces the number of trusted documents stored in the registry to the value set by the "Set maximum number of trust records to preserve" policy setting.

If you enable this policy setting, you can specify the maximum number of trusted documents to be stored in the registry before the purge task runs, with an upper limit of 20,000 documents. For performance reasons, we do not recommend setting this policy setting to the upper limit.

If you disable or do not configure this policy setting, the default value of 500 is used for the maximum number of trusted documents that can be stored in the registry before the purge task runs.

Registry

HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted documents
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_SetMaximumNumberOfTrustedDocuments
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\security\trusted documents'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
# Maximum number
Set-ItemProperty -Path $k -Name 'maxtrusteddocuments' -Value 500 -Type DWord  # between 0 and 20000

Disable

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

Revert to "Not configured"

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

Options (1)

LabelControlRegistry valueREG typeConstraints / details
Maximum number:L_SetMaximumNumberOfTrustedDocumentsSpinIDNumeric boxdecimalmaxtrusteddocumentsREG_DWORD
Min: 0 · Max: 20000 · Default (UI): 500

Application

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

Official templates downloaded on November 12, 2026.