Prompt for workbook properties
| Registry value | fpromptsuminfo_65_1 |
| Group Policy | Prompt for workbook properties |
| German version | Anfrage nach Dateieigenschaften |
| Intune settings catalog | Prompt for workbook properties (User) |
| Scope | User · HKCU |
| ADMX | excel16.admx · L_Promptforworkbookproperties |
Group Policy path
Registry
| Value | Data |
|---|---|
HKCU\Software\policies\microsoft\office\16.0\excel\options\binaryoptions | |
| fpromptsuminfo_65_1 | Enabled = 1 · Disabled = 0 |
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\binaryoptions"
foreach ($name in @('fpromptsuminfo_65_1')) {
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\binaryoptions"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'fpromptsuminfo_65_1' -PropertyType DWord -Value 1 -Force -ErrorAction Stop | Out-Null # Enabled
'Done.'
}
catch { Write-Error "Failed: $($_.Exception.Message)" }Disable
# --- Settings ---
$root = 'HKCU:' # other signed-in user (elevated): 'Registry::HKEY_USERS\<SID>'
try {
$key = "$root\Software\policies\microsoft\office\16.0\excel\options\binaryoptions"
if (-not (Test-Path $key)) { New-Item -Path $key -Force -ErrorAction Stop | Out-Null }
New-ItemProperty -Path $key -Name 'fpromptsuminfo_65_1' -PropertyType DWord -Value 0 -Force -ErrorAction Stop | Out-Null # Disabled
'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\binaryoptions" Remove-ItemProperty -Path $key -Name 'fpromptsuminfo_65_1' -ErrorAction SilentlyContinue 'Policy values removed (Not configured).'
Intune (settings catalog)
Prompt for workbook properties (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_ExcelOptions~L_Save/L_Promptforworkbookproperties |
| Data type | String |
| Value | <enabled/> · <disabled/> |
Cloud Policy
Cloud Policy (config.office.com → Customization → Policy Management) offers many user policies of the Microsoft 365 Apps – search for Prompt for workbook properties. It also applies to unmanaged devices and wins over GPO and Intune for the same setting.
Microsoft explanation
Checks/Unchecks the corresponding UI option.
Same category: Microsoft Excel 2016 › Excel Options › Save
- Keep the last AutoSaved versions of files for the next sessionkeepunsavedchanges
- Default file locationdefaultpath
- Default file formatdefaultformat
- Save AutoRecover infoautorecoverenabled
- AutoRecover timeautorecovertime
- AutoRecover save locationautorecoverpath
- AutoRecover delayautorecoverdelay
- Disable AutoRepublishdisableautorepublish
- Do not show AutoRepublish warning alertdisableautorepublishwarning
- Suppress file format compatibility dialog box for OpenDocument Spreadsheet formatdisablesaveaslosswarningopendocumentspreadsheet
All policies in this category · All 173 policies of excel16.admx