Office Compatibility Issues

Fix Excel Compatibility Checker Warnings in WPS Office Spreadsheets

Camila MilosovichCamila Milosovich Nov 13, 2026 869 views

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.

Fix Excel Compatibility Checker Warnings in WPS Office Spreadsheets
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Save As and choose .xls

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).

2
Read the Compatibility Checker summary

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.

3
Note feature locations

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.

4
Confirm or cancel save

If the listed losses are acceptable, click Save. If not, click Cancel and update the workbook before saving to .xls.

Compatibility warnings do not always mean corruption: A .xltm template is macro-enabled and newer than .xls, so the Compatibility Checker can flag expected feature differences.

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. 1. Open the workbook: Launch WPS Office Spreadsheets, click Menu > Open, and select the affected .xltm, .xlsx, or .xls file.
  2. 2. Choose Save As: Click Menu > Save As and select Excel 97-2003 Workbook (*.xls) to trigger the compatibility review.
  3. 3. Review warnings: Inspect the Compatibility Checker list for unsupported features, external links, defined names, charts, data validation, or VBA references.
  4. 4. Resolve or save: Use Data > Edit Links, Formulas > Name Manager, and sheet review to update references; then save when the warnings are acceptable.
Identifies unsupported features before saving to Excel 97-2003 formatOpens modern .xltm, .xlsx, and legacy .xls files without losing workflow contextFull compatibility with Microsoft Excel 97-2003 (.xls) and later formatsFree spreadsheet alternative with familiar menus and formula toolsLets you review links, defined names, and VBA references in one place
QA img-9

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.