This policy setting controls the default file format for saving workbooks in Excel 2007.
If you enable this policy setting, you can set the default file format for Excel 2007 from among the following options:
- Excel Workbook (.xlsx).This option is the default configuration in Excel 2007.
- Excel Macro-Enabled Workbook (.xlsm)
- Excel Binary Workbook (.xlsx)
- 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 this policy setting, Excel 2007 saves new workbooks in the Office Open XML format with an .xlsx extension, and users will not be able to change the default setting.
If you do not configure this policy setting, Excel 2007 saves new workbooks in the Office Open XML format with an .xlsx extension.
For users who run Excel 2000 with Service Pack 3, Excel 2002 with Service Pack 3, and Excel 2003 with at least Service Pack 1, Microsoft offers the Microsoft Office Compatibility Pack, which enables these versions of Excel to open and save .xlsx files. If some users in your organization cannot install the Compatibility Pack, or are running versions of Excel older than Excel 2000 with Service Pack 3, these users might not be able to access Excel files saved in the .xlsx format.
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 51 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 52 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 50 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 44 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 56 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 39 |
Registry Hive | HKEY_CURRENT_USER |
Registry Path | Software\Policies\Microsoft\Office\12.0\Excel\Options |
Value Name | DefaultFormat |
Value Type | REG_DWORD |
Value | 60 |