Microsoft Excel 2016 › Excel Options › Advanced
Number of folders in the Recent Folders list
Supported on SUPPORTED_Windows7 (defined in the Windows templates)
What it does
This policy setting specifies the number of unpinned entries displayed in the Recent Folders list that appears when users click Open or Save As on the File tab in Backstage view. If you enable this policy setting, you can specify the number of unpinned entries to be between 0 and 20. If you set the number to 0, all pinned and unpinned entries are hidden. If you disable or do not configure this policy setting, a maximum of 5 unpinned items are displayed in the Recent Folders list. Note: If you want to prevent items from being added to the Recent Folders list entirely, you can enable the "Do not keep history of recently opened documents" Windows policy setting.
What it writes
- Hive
- HKEY_CURRENT_USER
- Registry key
software\policies\microsoft\office\16.0\excel\place mru
Why it needs changes for Intune
- Policy references a Windows supportedOn definition.
- ADMX-INTUNE-WINDOWS-SUPPORTEDON-REFERENCE
Options
| Option | Type | Registry value | Allowed values |
|---|---|---|---|
| L_SetNumberOfPlacesInTheRecentPlacesListSpinIDDefault: 5 | Number | max display |
0 to 20 |
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\place mru]
"max display"=dword:00000005
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: Number of folders in the Recent Folders list
# Name: L_SetNumberOfPlacesInTheRecentPlacesList
# Scope: User
# State: Enabled
# Source: excel16.admx
Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\place mru' -Name 'max display' -PropertyType 'DWord' -Value 5
- 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.
ADMX profile candidate (OMA-URI)
./User/Vendor/MSFT/Policy/Config/ADMX_excel16/L_SetNumberOfPlacesInTheRecentPlacesListADMX SyncML candidate
<SyncML xmlns="SYNCML:SYNCML1.2">
<SyncBody>
<Replace>
<CmdID>1</CmdID>
<Item>
<Meta>
<Format>chr</Format>
<Type>text/plain</Type>
</Meta>
<Target>
<LocURI>./User/Vendor/MSFT/Policy/Config/ADMX_excel16/L_SetNumberOfPlacesInTheRecentPlacesList</LocURI>
</Target>
<Data><enabled/>
<data id="L_SetNumberOfPlacesInTheRecentPlacesListSpinID" value="5"/></Data>
</Item>
</Replace>
<Final/>
</SyncBody>
</SyncML>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: Number of folders in the Recent Folders list
# Name: L_SetNumberOfPlacesInTheRecentPlacesList
# Scope: User
# State: Enabled
# Source: excel16.admx
$isMatch = Test-RegistryValueEquals -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\place mru' -Name 'max display' -Kind 'DWord' -Expected 5
if (-not $isMatch) {
$reasons.Add('Value mismatch: HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\place mru\max display') | 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: Number of folders in the Recent Folders list
# Name: L_SetNumberOfPlacesInTheRecentPlacesList
# Scope: User
# State: Enabled
# Source: excel16.admx
Set-RegistryValue -Path 'Registry::HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\place mru' -Name 'max display' -PropertyType 'DWord' -Value 5
History 1 retained release
- 5568.100010 Aug 2026
- Already present in the first release ChangeIntel keeps.
Template
- Internal name
L_SetNumberOfPlacesInTheRecentPlacesList- 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_SetNumberOfPlacesInTheRecentPlacesList)" explainText="$(string.L_SetNumberOfPlacesInTheRecentPlacesListExplain)" key="software\policies\microsoft\office\16.0\excel\place mru" name="L_SetNumberOfPlacesInTheRecentPlacesList" presentation="$(presentation.L_SetNumberOfPlacesInTheRecentPlacesList)" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
<parentCategory ref="excel16.Office.Microsoft.Policies.Windows:L_Advanced" />
<supportedOn ref="Microsoft.Policies.Windows:SUPPORTED_Windows7" />
<elements>
<decimal id="L_SetNumberOfPlacesInTheRecentPlacesListSpinID" maxValue="20" minValue="0" valueName="max display" />
</elements>
</policy>Editor controls
<presentation id="L_SetNumberOfPlacesInTheRecentPlacesList" xmlns="http://schemas.microsoft.com/GroupPolicy/2006/07/PolicyDefinitions">
<decimalTextBox defaultValue="5" refId="L_SetNumberOfPlacesInTheRecentPlacesListSpinID" spinStep="1">
</decimalTextBox>
</presentation>Supported platforms and category
excel16.Office.Microsoft.Policies.Windows:category:L_Advanced
<category displayName="$(string.L_Advanced)" name="L_Advanced" 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_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:unresolved:Microsoft.Policies.Windows:SUPPORTED_Windows7
<unresolved reference="Microsoft.Policies.Windows:SUPPORTED_Windows7" />
excel16.Office.Microsoft.Policies.Windows:category:L_Advanced
<category displayName="$(string.L_Advanced)" name="L_Advanced" 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_Advanced">Advanced</string></strings>
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>