Fix Excel 2016 Crashes When Saving Older Workbooks
Question details
The user needs to save older Excel workbooks without Excel 2016 crashing.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows 10
- Scenario
- Saving workbooks created in Excel 2010, some of which may use the older XLS format.
- Observed behavior
- Excel crashes during saving without an error message. Office repair and Safe Mode have not resolved the issue.
In File Explorer, check the workbook's extension and copy the file to a local folder before testing. If extensions are hidden, select View and enable File name extensions.
Save an older XLS workbook in a newer format
Try a new file format if the affected workbook is an older XLS file that opens in Excel.
Older XLS workbooks may open in Compatibility Mode. Converting a copy can avoid some legacy-format issues, but it may change formatting or unsupported features.
In Excel, select File > Open and open the local copy of the affected workbook.
Select File > Save As, choose a local folder, and select Excel Workbook (*.xlsx) from the file type list. If the workbook contains macros that you need to keep, select Excel Macro-Enabled Workbook (*.xlsm) instead.
Enter a new file name and select Save. Reopen the new file and check its formulas, formatting, and any required features.

Repair the workbook with Open and Repair
Use Excel's repair option if a workbook may be damaged or cannot be saved in a new format.
Check and update the Office 2016 build
Check for Office updates if the crash affects multiple workbooks, including repaired or converted copies.
Work with older spreadsheets in WPS Office
WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Open compatible Excel files and continue working in a new application; it does not repair the Excel 2016 installation or guarantee that every workbook feature will transfer.

Frequently Asked Questions
Why does an XLS workbook open in Compatibility Mode?
XLS is an older Excel file format, so Excel may use Compatibility Mode to preserve its format. To try a newer format, select File > Save As and choose Excel Workbook (*.xlsx).
Will saving an XLS file as XLSX keep its macros?
No. If you need to retain macros, use File > Save As and select Excel Macro-Enabled Workbook (*.xlsm) instead of XLSX.
What can I do if Excel crashes during Save As?
Try File > Open > Browse, select a copy of the workbook, and choose Open and Repair from the arrow next to Open. If repair fails, try Extract Data.
How can I check my Excel 2016 build?
Select File > Account > About Excel to see the version and build. On the Account page, Update Options > Update Now may be available to install updates.




