Policy
Default file format
Microsoft Office
Policy overview
Key metadata and intent for this policy.
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.
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.
| Scope | Element | Type | Registry mapping | Constraints & behavior | Copy |
|---|---|---|---|---|---|
| User | Save Excel files as ID L_saveexcelfilesas1 | enum | Path software\policies\microsoft\office\16.0\excel\options Value name 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) |