'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix Excel Compatibility Warning When Saving a Workbook
Question details
The user encounters a compatibility warning when attempting to save an Excel workbook, preventing the use of modern functionalities.
- Product
- Excel
- Device & OS
- not provided
- Scenario
- Saving a workbook originally created or formatted in the legacy Excel 97-2003 (.xls) file format.
- Observed behavior
- A compatibility warning appears during the saving process, stating that sorting and formatting information may be lost, and features like AutoSave are disabled due to Compatibility Mode.
Before converting your file format, create a backup copy of your original .xls document to ensure your initial data remains secure.
Convert the Legacy Workbook to the Modern .xlsx Format
Upgrading the file format from legacy .xls to the current .xlsx or .xlsm format resolves compatibility warnings and re-enables modern features.
Excel displays the Compatibility Checker warning because the legacy Excel 97-2003 (.xls) format cannot support modern spreadsheet features. Saving the file in the updated XML-based format (.xlsx) will resolve the issue permanently.
Click on 'File' in the top-left corner of the application and select 'Save As'.
Open the 'Save as type' or 'File Format' dropdown menu. Select 'Excel Workbook (*.xlsx)'. If your workbook contains macros, choose 'Excel Macro-Enabled Workbook (*.xlsm)' instead.
Choose a destination folder, rename the file if desired, and click 'Save'.
Close the current workbook and open the newly saved .xlsx file. Verify that your data and formatting are intact, and confirm that the compatibility warning no longer appears.
Easily Convert Legacy Spreadsheets with WPS Office
WPS Spreadsheet offers high compatibility with all Microsoft Excel formats, allowing you to seamlessly convert legacy .xls files to modern .xlsx files without losing data or formatting.
- 1. Open your file: Launch WPS Spreadsheet and open your legacy .xls workbook.
- 2. Access the Save As menu: Click on 'Menu' in the top-left corner and select 'Save As' from the dropdown list.
- 3. Choose .xlsx format: In the dialog box, select 'Microsoft Excel Workbook (*.xlsx)' from the File Type dropdown menu.
- 4. Save your document: Click 'Save' to instantly convert your file and eliminate legacy compatibility warnings.
Frequently Asked Questions
Why do I get a compatibility warning when opening old Excel files?
Old Excel files (the 97-2003 .xls format) do not support newer features like dynamic arrays, certain advanced conditional formatting, or AutoSave. The warning notifies you that these newer features cannot be saved properly in the legacy format.
What is the difference between .xlsx and .xlsm formats?
The .xlsx format is the standard modern Excel file format used for regular spreadsheets. The .xlsm format is used specifically for workbooks that contain VBA macros or custom scripting, which are blocked in standard .xlsx files for security reasons.
Can I disable the compatibility checker permanently?
While you can uncheck the 'Check compatibility when saving this workbook' box within the compatibility checker dialog box, it is not recommended. The best permanent fix is converting your document to the standard .xlsx format so that modern features work properly.
Will converting from .xls to .xlsx change my existing data?
No, converting simply updates the underlying file structure to an XML-based format to allow for newer features. Your underlying data, formulas, and text will remain intact.
