Personal templates path for Excel
| Registry value | personaltemplates |
| Group Policy | Personal templates path for Excel |
| German version | Pfad zu Persönliche Vorlagen für Excel |
| Intune settings catalog | Personal templates path for Excel (User) |
| Scope | User · HKCU |
| ADMX | excel16.admx · L_PersonalTemplatesPath |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\excel\options | |
| personaltemplates | text |
Not configured = the value does not exist – the application default applies and users may change the setting.
PowerShell
Check the current value (read-only)
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
$key = "$root\Software\policies\microsoft\office\16.0\excel\options"
foreach ($name in @('personaltemplates')) {
try { '{0} = {1}' -f $name, (Get-ItemPropertyValue -Path $key -Name $name -ErrorAction Stop) }
catch { '{0}: not configured' -f $name }
}Admin rights needed: HKCU\Software\Policies is read-only for standard users. An elevated session writes to the admin's own HKCU – to set it for another signed-in user, change $root to Registry::HKEY_USERS\<SID>.
Enable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'personaltemplates' -PropertyType String -Value '<value>' -Force -ErrorAction Stop | Out-Null # your value
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Reset to Not configured
# --- Settings --- $root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>' $key = "$root\Software\policies\microsoft\office\16.0\excel\options" Remove-ItemProperty -Path $key -Name 'personaltemplates' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Personal templates path for Excel (User)
Settings catalog → Add settings → search for the name above.
Intune Settings Catalog Viewer ↗
Alternative: custom profile (OMA-URI)
| OMA-URI | ./User/Vendor/MSFT/Policy/Config/excel16v2~Policy~L_MicrosoftOfficeExcel~L_miscellaneous168/L_PersonalTemplatesPath |
| Data type | String |
| Value | <enabled/> · <disabled/> |
This policy has options: add one <data id="…" value="…"/> per element after <enabled/>. The element IDs are in the ADMX file.
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Personal templates path for Excel. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft explanation
This policy setting specifies the location of a user's personal templates.
If you enable this policy setting, users will see any templates they have saved in the specified location in the custom templates tab on the Office Start screen and in File | New and when saving a template their default folder will change to be the specified location.
If you disable or do not configure this policy setting, users will not see templates they have saved in the custom templates tab on the Office Start screen and in File | New and when saving a template their default folder will be their document save location.
Same category: Microsoft Excel 2016 › Miscellaneous
- Graph gallery pathgallerypath
- Enable four-digit year displayenablefourdigityeardisplay
- Do not cache network files locallynetworkresiliency
- OLAP PivotTable User Defined Function (UDF) security settingolapudfsecurity
- Block all unmanaged add-insrestricttolist
- List of managed add-ins
- Disable the Office Start screen for Exceldisableboottoofficestart
- Show custom templates tab by default in Excel on the Office Start screen and in File | Newofficestartdefaulttab
- Disable Office Scripts in Excel for Windows Desktopdisableofficescripts
All policies in this category · All 173 policies of excel16.admx