Microsoft 365 Apps Group Policy settings

2,420 settings · 5568.1000 · 10 Aug 2026

22 settingsCSV

Microsoft Excel 2016 › Excel Options › Security › Trust Center › Trusted Locations

Trusted Location #16

UserNeeds changes for IntuneL_TrustedLoc16

Supported on SUPPORTED_Windows7 (defined in the Windows templates)

5568.1000

What it does

This policy setting allows you to specify a folder as a trusted location from which to open 2016 Word, Excel, PowerPoint, Access and Visio files. Files in trusted locations bypass file validation, active content checks and Protected View. Macros and code in these files will execute without displaying warnings to the user. If you change or add a location make sure that the new location is secured, with only appropriate user permissions to add document/files. If you enable this policy setting, you can specify a trusted location (or folder) from which the 2016 Office application can open the files which run macros without warning. If you disable or do not configure this policy setting, the trusted location is not specified.

What it writes

Hive: HKEY_CURRENT_USER
Registry key: software\policies\microsoft\office\16.0\excel\security\trusted locations\location16

Why it needs changes for Intune

Policy references a Windows supportedOn definition.
ADMX-INTUNE-WINDOWS-SUPPORTEDON-REFERENCE

Options

Option	Type	Registry value	Allowed values
Path	Text	`path`	Up to 255 characters
Date	Text	`date`	Up to 255 characters
Description	Text	`description`	Up to 255 characters
Allow sub folders	Checkbox	`allowsubfolders`	On (1) or off (0)

Configure and deploy

Choose a state and the option values; the output below is generated from the template for exactly that.

Enabled · User · template defaults

Registry file (.reg)

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16]
"allowsubfolders"=dword:00000001
"date"=""
"description"=""
"path"=hex(2):00,00

PowerShell

$ErrorActionPreference = 'Stop'

function Set-RegistryValue {
    param(
        [Parameter(Mandatory = $true)][string] $Path,
        [Parameter(Mandatory = $true)][string] $Name,
        [Parameter(Mandatory = $true)][string] $PropertyType,
        [Parameter(Mandatory = $true)][object] $Value
    )

    if (-not (Test-Path -LiteralPath $Path)) {
        New-Item -Path $Path -Force | Out-Null
    }

    New-ItemProperty -LiteralPath $Path -Name $Name -PropertyType $PropertyType -Value $Value -Force | Out-Null
}

function Remove-RegistryValue {
    param(
        [Parameter(Mandatory = $true)][string] $Path,
        [Parameter(Mandatory = $true)][string] $Name
    )

    if (Test-Path -LiteralPath $Path) {
        Remove-ItemProperty -LiteralPath $Path -Name $Name -Force -ErrorAction SilentlyContinue
    }
}

function Clear-RegistryKeyValues {
    param(
        [Parameter(Mandatory = $true)][string] $Path
    )

    if (-not (Test-Path -LiteralPath $Path)) {
        return
    }

    foreach ($propertyName in (Get-Item -LiteralPath $Path).Property) {
        Remove-ItemProperty -LiteralPath $Path -Name $propertyName -Force -ErrorAction SilentlyContinue
    }
}

# Policy: Trusted Location #16
# Name: L_TrustedLoc16
# Scope: User
# State: Enabled
# Source: excel16.admx

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'path' -PropertyType 'ExpandString' -Value ''

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'date' -PropertyType 'String' -Value ''

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'description' -PropertyType 'String' -Value ''

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'allowsubfolders' -PropertyType 'DWord' -Value 1

The OMA-URI is an inferred ADMX-backed Policy CSP candidate derived from the source ADMX file name and policy name.
Some Microsoft policies use built-in Policy CSP pages whose area names don't match the ADMX file name, so verify the candidate against Microsoft Learn before deployment.
The generated payload is incomplete because one or more ADMX element values were not supplied: L_pathcolon61, L_datecolon62, L_descriptioncolon63, L_allowsubfolders64

ADMX profile candidate (OMA-URI)

./User/Vendor/MSFT/Policy/Config/ADMX_excel16/L_TrustedLoc16

Intune remediation scripts

Detection

$ErrorActionPreference = 'Stop'
$reasons = [System.Collections.Generic.List[string]]::new()

function Test-RegistryValueExists {
    param(
        [Parameter(Mandatory = $true)][string] $Path,
        [Parameter(Mandatory = $true)][string] $Name
    )

    if (-not (Test-Path -LiteralPath $Path)) {
        return $false
    }

    return $null -ne (Get-ItemProperty -LiteralPath $Path -Name $Name -ErrorAction SilentlyContinue)
}

function Test-RegistryValueEquals {
    param(
        [Parameter(Mandatory = $true)][string] $Path,
        [Parameter(Mandatory = $true)][string] $Name,
        [Parameter(Mandatory = $true)][string] $Kind,
        [Parameter(Mandatory = $true)][object] $Expected
    )

    if (-not (Test-Path -LiteralPath $Path)) {
        return $false
    }

    $valueObject = Get-ItemProperty -LiteralPath $Path -Name $Name -ErrorAction SilentlyContinue
    if ($null -eq $valueObject) {
        return $false
    }

    $actual = $valueObject.$Name
    switch ($Kind) {
        'String' { return [string]$actual -ceq [string]$Expected }
        'ExpandString' { return [string]$actual -ceq [string]$Expected }
        'DWord' { return [uint32]$actual -eq [uint32]$Expected }
        'QWord' { return [uint64]$actual -eq [uint64]$Expected }
        'MultiString' {
            $actualArray = @($actual)
            $expectedArray = @($Expected)
            if ($actualArray.Count -ne $expectedArray.Count) { return $false }
            for ($index = 0; $index -lt $actualArray.Count; $index++) {
                if ([string]$actualArray[$index] -cne [string]$expectedArray[$index]) { return $false }
            }
            return $true
        }
        'Binary' {
            $actualArray = [byte[]]$actual
            $expectedArray = [byte[]]$Expected
            if ($actualArray.Length -ne $expectedArray.Length) { return $false }
            for ($index = 0; $index -lt $actualArray.Length; $index++) {
                if ($actualArray[$index] -ne $expectedArray[$index]) { return $false }
            }
            return $true
        }
        default { return [string]$actual -ceq [string]$Expected }
    }
}

# Policy: Trusted Location #16
# Name: L_TrustedLoc16
# Scope: User
# State: Enabled
# Source: excel16.admx

$isMatch = Test-RegistryValueEquals -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'path' -Kind 'ExpandString' -Expected ''
if (-not $isMatch) {
    $reasons.Add('Value mismatch: HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16\path') | Out-Null
}

$isMatch = Test-RegistryValueEquals -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'date' -Kind 'String' -Expected ''
if (-not $isMatch) {
    $reasons.Add('Value mismatch: HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16\date') | Out-Null
}

$isMatch = Test-RegistryValueEquals -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'description' -Kind 'String' -Expected ''
if (-not $isMatch) {
    $reasons.Add('Value mismatch: HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16\description') | Out-Null
}

$isMatch = Test-RegistryValueEquals -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'allowsubfolders' -Kind 'DWord' -Expected 1
if (-not $isMatch) {
    $reasons.Add('Value mismatch: HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16\allowsubfolders') | Out-Null
}

if ($reasons.Count -eq 0) {
    Write-Output 'Compliant'
    exit 0
}

$reasons | ForEach-Object { Write-Output $_ }
exit 1

Remediation

$ErrorActionPreference = 'Stop'

function Set-RegistryValue {
    param(
        [Parameter(Mandatory = $true)][string] $Path,
        [Parameter(Mandatory = $true)][string] $Name,
        [Parameter(Mandatory = $true)][string] $PropertyType,
        [Parameter(Mandatory = $true)][object] $Value
    )

    if (-not (Test-Path -LiteralPath $Path)) {
        New-Item -Path $Path -Force | Out-Null
    }

    New-ItemProperty -LiteralPath $Path -Name $Name -PropertyType $PropertyType -Value $Value -Force | Out-Null
}

function Remove-RegistryValue {
    param(
        [Parameter(Mandatory = $true)][string] $Path,
        [Parameter(Mandatory = $true)][string] $Name
    )

    if (Test-Path -LiteralPath $Path) {
        Remove-ItemProperty -LiteralPath $Path -Name $Name -Force -ErrorAction SilentlyContinue
    }
}

function Clear-RegistryKeyValues {
    param(
        [Parameter(Mandatory = $true)][string] $Path
    )

    if (-not (Test-Path -LiteralPath $Path)) {
        return
    }

    foreach ($propertyName in (Get-Item -LiteralPath $Path).Property) {
        Remove-ItemProperty -LiteralPath $Path -Name $propertyName -Force -ErrorAction SilentlyContinue
    }
}

# Policy: Trusted Location #16
# Name: L_TrustedLoc16
# Scope: User
# State: Enabled
# Source: excel16.admx

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'path' -PropertyType 'ExpandString' -Value ''

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'date' -PropertyType 'String' -Value ''

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'description' -PropertyType 'String' -Value ''

Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\security\trusted locations\location16' -Name 'allowsubfolders' -PropertyType 'DWord' -Value 1

History 1 retained release

5568.100010 Aug 2026
- Already present in the first release ChangeIntel keeps.

Template

Internal name: L_TrustedLoc16
Namespace: excel16.Office.Microsoft.Policies.Windows
Template file: excel16.admx
Release: Microsoft 365 Apps 5568.1000 · file set 8be05d876aae137d…

Definition, editor controls and support

Definition

<policy class="User" displayName="$(string.L_TrustedLoc16)" explainText="$(string.L_TrustedLocationsExplain)" key="software\policies\microsoft\office\16.0\excel\security\trusted locations\location16" name="L_TrustedLoc16" presentation="$(presentation.L_TrustedLoc16)" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_TrustedLocations" />
      <supportedOn ref="Microsoft.Policies.Windows:SUPPORTED_Windows7" />
      <elements>
        <text expandable="true" id="L_pathcolon61" valueName="path" />
        <text id="L_datecolon62" valueName="date" />
        <text id="L_descriptioncolon63" valueName="description" />
        <boolean id="L_allowsubfolders64" valueName="allowsubfolders">
          <trueValue>
            <decimal value="1" />
          </trueValue>
          <falseValue>
            <decimal value="0" />
          </falseValue>
        </boolean>
      </elements>
    </policy>

Editor controls

<presentation id="L_TrustedLoc16" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
        <textBox refId="L_pathcolon61">
          <label>Path:</label>
        </textBox>
        <textBox refId="L_datecolon62">
          <label>Date:</label>
        </textBox>
        <textBox refId="L_descriptioncolon63">
          <label>Description:</label>
        </textBox>
        <checkBox refId="L_allowsubfolders64">Allow sub folders:</checkBox>
      </presentation>

Supported platforms and category

excel16.Office.Microsoft.Policies.Windows:category:L_ExcelOptions
<category displayName="$(string.L_ExcelOptions)" name="L_ExcelOptions" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_MicrosoftOfficeExcel" />
    </category>
excel16.Office.Microsoft.Policies.Windows:category:L_MicrosoftOfficeExcel
<category displayName="$(string.L_MicrosoftOfficeExcel)" name="L_MicrosoftOfficeExcel" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions" />
excel16.Office.Microsoft.Policies.Windows:category:L_Security
<category displayName="$(string.L_Security)" name="L_Security" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_ExcelOptions" />
    </category>
excel16.Office.Microsoft.Policies.Windows:category:L_TrustCenter
<category displayName="$(string.L_TrustCenter)" name="L_TrustCenter" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_Security" />
    </category>
excel16.Office.Microsoft.Policies.Windows:category:L_TrustedLocations
<category displayName="$(string.L_TrustedLocations)" name="L_TrustedLocations" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_TrustCenter" />
    </category>
excel16.Office.Microsoft.Policies.Windows:unresolved:Microsoft.Policies.Windows:SUPPORTED_Windows7
<unresolved reference="Microsoft.Policies.Windows:SUPPORTED_Windows7" />
excel16.Office.Microsoft.Policies.Windows:category:L_ExcelOptions
<category displayName="$(string.L_ExcelOptions)" name="L_ExcelOptions" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_MicrosoftOfficeExcel" />
    </category>
<strings><string id="excel16.Office.Microsoft.Policies.Windows:L_ExcelOptions">Excel Options</string></strings>
excel16.Office.Microsoft.Policies.Windows:category:L_MicrosoftOfficeExcel
<category displayName="$(string.L_MicrosoftOfficeExcel)" name="L_MicrosoftOfficeExcel" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions" />
<strings><string id="excel16.Office.Microsoft.Policies.Windows:L_MicrosoftOfficeExcel">Microsoft Excel 2016</string></strings>
excel16.Office.Microsoft.Policies.Windows:category:L_Security
<category displayName="$(string.L_Security)" name="L_Security" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_ExcelOptions" />
    </category>
<strings><string id="excel16.Office.Microsoft.Policies.Windows:L_Security">Security</string></strings>
excel16.Office.Microsoft.Policies.Windows:category:L_TrustCenter
<category displayName="$(string.L_TrustCenter)" name="L_TrustCenter" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_Security" />
    </category>
<strings><string id="excel16.Office.Microsoft.Policies.Windows:L_TrustCenter">Trust Center</string></strings>
excel16.Office.Microsoft.Policies.Windows:category:L_TrustedLocations
<category displayName="$(string.L_TrustedLocations)" name="L_TrustedLocations" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
      <parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_TrustCenter" />
    </category>
<strings><string id="excel16.Office.Microsoft.Policies.Windows:L_TrustedLocations">Trusted Locations</string></strings>