Always prevent untrusted Microsoft Query files from opening
Explanation
This policy setting controls whether Microsoft Query files (.iqy, oqy, .dqy, and .rqy) in an untrusted location are prevented from opening.
If you enable this policy setting, Microsoft Query files in an untrusted location are prevented from opening. Users will not be able to change this setting under File > Options > Trust Center > Trust Center Settings > External Content.
If you disable or don’t configure this policy setting, Microsoft Query files in an untrusted location are not prevented from opening, unless users have changed this setting in the Trust Center.
Note: This policy setting only applies to subscription versions of Office, such as Microsoft 365 Apps for enterprise.
Registry
HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\external content- Value name
enableblockunsecurequeryfiles
| State | Value written |
|---|---|
| Enabled | REG_DWORD = 1 |
| Disabled | REG_DWORD = 0 |
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_EnableBlockUnsecureQueryFiles
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\security\external content'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'enableblockunsecurequeryfiles' -Value 1 -Type DWordDisable
# Disable: excel16/L_EnableBlockUnsecureQueryFiles
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\security\external content'
if (-not (Test-Path -Path $k)) { New-Item -Path $k -Force | Out-Null }
Set-ItemProperty -Path $k -Name 'enableblockunsecurequeryfiles' -Value 0 -Type DWordRevert to "Not configured"
# Revert to "Not configured": excel16/L_EnableBlockUnsecureQueryFiles
$k = 'HKCU:\software\policies\microsoft\office\16.0\excel\security\external content'
Remove-ItemProperty -Path $k -Name 'enableblockunsecurequeryfiles' -ErrorAction SilentlyContinueApplication
Microsoft 365 Apps / Office (Microsoft) — November 2026 templates
Official templates downloaded on November 12, 2026.