en-US office user

Suppress file format compatibility dialog box for OpenDocument Spreadsheet format

Verified with Microsoft 365/Office 5568.1000 — updated on September 4, 2026 Supported on: At least Windows Server 2008 R2 or Windows 7

Microsoft 365/Office 5568.1000

Path in the GPO console

User Configuration\Administrative Templates\Microsoft Excel 2016\Excel Options\Save

Registry

HKCU software\policies\microsoft\office\16.0\excel\options
Value name:
disablesaveaslosswarningopendocumentspreadsheet REG_DWORD
Enabled:
1
Disabled:
0

Description

This policy setting allows you to configure the file format compatibility dialog box when saving a file as an OpenDocument Spreadsheet file in Microsoft Excel. If you enable this policy setting, the file format compatibility dialog is not displayed whenever you save as an OpenDocument Spreadsheet file in Excel. If you disable or do not configure this policy setting, the file format compatibility dialog is displayed when you save as an OpenDocument Spreadsheet file in Excel.

Export Builder

BETA

Configure the state, scope and options, then generate .reg, PowerShell, Intune and SCCM outputs — or add the setting to a multi-setting collection.

These exports write the registry — this is not a managed GPO. ⓘ

.reg file

Windows Registry Editor Version 5.00

; Exported from gporais.com
; Policy: Suppress file format compatibility dialog box for OpenDocument Spreadsheet format
; State: Enabled
; Supported on: At least Windows Server 2008 R2 or Windows 7

[HKEY_CURRENT_USER\software\policies\microsoft\office\16.0\excel\options]
"disablesaveaslosswarningopendocumentspreadsheet"=dword:00000001
More formats (PowerShell, Intune, SCCM)

PowerShell

# Exported from gporais.com
# Policy: Suppress file format compatibility dialog box for OpenDocument Spreadsheet format
# State: Enabled
# Supported on: At least Windows Server 2008 R2 or Windows 7
# Warning: In SYSTEM context (the Intune default), HKCU targets the SYSTEM profile. Run this script using the logged-on credentials.

$path = 'HKCU:\software\policies\microsoft\office\16.0\excel\options'
New-Item -Path $path -Force | Out-Null
Set-ItemProperty -Path $path -Name 'disablesaveaslosswarningopendocumentspreadsheet' -Value 1 -Type DWord

Building a multi-setting collection? Add this setting and generate combined .reg / PowerShell / GPO scripts.

Open the Builder

Embed this policy on your site

What to embed
Theme

Adds one script line: the theme follows your site’s appearance and the height fits the content. If your site blocks scripts, the embed follows the visitor’s system theme.

Preview