Fix Excel Compatibility Checker Warnings in WPS Office Spreadsheets
Question details
The user wants to understand why Excel Compatibility Checker reports Excel 97–2003 compatibility issues in a workbook that uses a modern .xltm template, and how to review unsupported features, external links, defined names, formulas, charts, data validation, and VBA references.

- Product
- WPS Office Spreadsheets
- Device & OS
- not provided
- Scenario
- Checking a modern .xltm workbook for compatibility before saving to or sharing with older Excel 97–2003 formats.
- Observed behavior
- The Compatibility Checker lists features that may not be supported by older Excel formats, but this does not necessarily indicate file corruption.
Open the affected workbook in WPS Office Spreadsheets and select Menu > Save As to confirm whether the target format is Excel 97-2003 Workbook (*.xls). Keep the Compatibility Checker details visible so you can match each warning to its sheet.
Review Compatibility Checker Warnings Before Saving an Excel 97–2003 Workbook in WPS Office
Use this solution when you need to save or distribute a workbook in .xls format and want to identify which features may be lost.
The Compatibility Checker is informational, not a corruption indicator. It compares the current workbook against the older .xls file format and reports features that may be lost or changed.
In WPS Office Spreadsheets, open the workbook, click the Menu button in the top-left corner, choose Save As, and select Excel 97-2003 Workbook (*.xls).
In the save dialog or compatibility prompt, review the list of features that may be lost or degraded, such as unsupported formatting, tables, or functions.
Click each compatibility warning or switch to the referenced sheet to locate cells, charts, data validation rules, or defined names that use newer Excel features.
If the listed losses are acceptable, click Save. If not, click Cancel and update the workbook before saving to .xls.
Inspect External Links, Defined Names, and VBA References for Old Workbook References
Use this solution when compatibility warnings point to external links or when the workbook was created from a template that references another workbook.
Check and Resolve Excel 97–2003 Compatibility Warnings in WPS Office Spreadsheets
Open your .xltm or .xlsx workbook in WPS Office Spreadsheets, use Save As to target Excel 97-2003 Workbook (.xls), and review the compatibility warnings for external links, formulas, charts, data validation, and VBA references before saving.
- 1. Open the workbook: Launch WPS Office Spreadsheets, click Menu > Open, and select the affected .xltm, .xlsx, or .xls file.
- 2. Choose Save As: Click Menu > Save As and select Excel 97-2003 Workbook (*.xls) to trigger the compatibility review.
- 3. Review warnings: Inspect the Compatibility Checker list for unsupported features, external links, defined names, charts, data validation, or VBA references.
- 4. Resolve or save: Use Data > Edit Links, Formulas > Name Manager, and sheet review to update references; then save when the warnings are acceptable.

Frequently Asked Questions
Does a .xltm file mean my workbook is already in Excel 97–2003 format?
No. The .xltm extension is a macro-enabled Excel template and is not the same as the legacy .xls format. The Compatibility Checker may warn because the older .xls target cannot support all newer template features.
Why does Compatibility Checker show warnings even though my file opens fine?
It lists features that may not survive if the workbook is saved as an Excel 97–2003 file. This is a compatibility notice, not necessarily a sign that the file is corrupted.
How do I find the external links mentioned in the compatibility report?
In WPS Office Spreadsheets, click Data > Edit Links. Also check Formulas > Name Manager, formulas, chart data ranges, data validation rules, and VBA code for references to the other workbook.
Can I ignore Compatibility Checker warnings and still save?
You can save, but the flagged features may be removed or changed in the .xls file. Save a copy first and confirm that the expected feature losses are acceptable.
Does WPS Office support Excel 97-2003 .xls files?
Yes. WPS Office Spreadsheets can open, edit, and save .xls, .xlsx, and .xltm formats, and it helps you review compatibility warnings to preserve older file behavior.




