Policy

Default file format

Microsoft Office 5532.1000

Back to categoryOpen picker

Policy overview

Key metadata and intent for this policy.

ClassUser
CategoryMicrosoft Excel 2016 > Excel Options > Save
Supported onWindows7

This policy setting controls the default file format for saving workbooks in Excel. If you enable this policy setting, you can set the default file format for Excel from among the following options: - Excel Workbook (.xlsx).This option is the default configuration in Excel 2016. - Excel Macro-Enabled Workbook (.xlsm) - Excel Binary Workbook (.xlsb) - Web Page (.htm; .html) - Excel 97-2003 Workbook (.xls) - Excel 5.0/95 Workbook (.xls) - OpenDocument Spreadsheet (*.ods) Users can choose to save workbooks in a different file format than the default. If you disable or you do not configure this policy setting, Excel saves new workbooks in the Office Open XML format with an .xlsx extension.

Internal name
L_SaveExcelfilesas
Policy ID
5e1c761b1e53
Elements
1

Registry values

How enabled and disabled states update the registry.

No explicit registry values are set for enabled or disabled states.

Policy elements

Inputs and configuration options exposed by this policy.

ElementTypeRegistry mappingConstraints & behavior
Save Excel files as
ID L_saveexcelfilesas1
enum
HKCU\software\policies\microsoft\office\16.0\excel\options\defaultformat
Type REG_DWORD
Options: Excel Workbook (*.xlsx) (51), Excel Macro-Enabled Workbook (*.xlsm) (52), Excel Binary Workbook (*.xlsb) (50), Web Page (*.htm; *.html) (44), Excel 97-2003 Workbook (*.xls) (56), Excel 5.0/95 Workbook (*.xls) (39), OpenDocument Spreadsheet (*.ods) (60)

Other policies in this category

Explore related policies at the same level.