Default file format

Policy ID
L_SaveExcelfilesas
Scope
User Configuration
Supported on
At least Windows Server 2008 R2 or Windows 7
Source
Microsoft 365 Apps / Office Administrative Templates (version 5568.1000)
Category
Microsoft Excel 2016 › Excel Options › Save

Description

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.

Options

  • Save Excel files as
    • Excel Workbook (*.xlsx)
    • 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)

Registry

Other policies in the same category

View all policies in this category (11)