File Format & Compatibility

Test Excel 2019 Workbook Compatibility with Excel 2013

Natalie TaylorNatalie Taylor Nov 13, 2026 869 views

Question details

The user wants to understand why Excel 2019 Compatibility Mode does not fully reproduce Excel 2013 behavior when testing formulas, macros, and workbook features, and how to reliably check compatibility.

Test Excel 2019 Workbook Compatibility with Excel 2013
Product
Microsoft Excel 2019 and Microsoft Excel 2013
Device & OS
not provided
Scenario
The user is saving or opening an Excel 2019 workbook in an older format such as .xls and needs to verify that formulas, macros, and workbook features will work in Excel 2013.
Observed behavior
Excel 2019 Compatibility Mode is not a complete emulator of Excel 2013; it can still calculate or display newer features such as TEXTJOIN, while Excel 2013 may return errors for the same workbook.
Before you start

Have the source workbook available in Excel 2019 and arrange access to a computer or virtual machine running Excel 2013. Keep a separate copy of the workbook so you can compare behavior between versions without changing the original file.

Solution 1Recommended

Use the Compatibility Checker and Test the Workbook in Excel 2013

Use this method when you need reliable confirmation that formulas, macros, formatting, and objects will work in Excel 2013 after saving from Excel 2019.

Compatibility Mode in Excel 2019 is not a complete emulator of Excel 2013. The Compatibility Checker flags known unsupported features when you save in an older format such as .xls, but final verification still requires opening the saved workbook in the actual target version.

1
Save the workbook as .xls

In Excel 2019, click File > Save As, choose a location, and set the file type to Excel 97-2003 Workbook (*.xls).

2
Review the Compatibility Checker results

When the Compatibility Checker appears after saving, click Find to jump to cells or features that may not be compatible with earlier Excel versions.

3
Identify unsupported formulas, macros, and objects

Review the summary for flagged formulas, macros, formatting, or objects, and decide whether to replace them or document the expected behavior.

4
Open and test the saved workbook in Excel 2013

Copy the saved file to a computer that has Excel 2013, open it, recalculate formulas, run macros, and confirm that all workbook features behave as expected.

Test in the target version: Only opening and testing the workbook in Excel 2013 gives reliable confirmation of actual compatibility.
Free Microsoft Office alternative

Use WPS Office as a Free Alternative for Excel-Compatible Workbook Editing

WPS Office cannot change Microsoft Excel 2019 compatibility rules, but it provides a free, lightweight environment to open, inspect, edit, and save Excel workbooks in .xlsx and .xls formats. Its familiar ribbon interface helps you work with spreadsheets without requiring Excel 2013 or an Office 365 subscription.

  1. 1. Download WPS Office: Go to the official WPS Office site and click Download WPS Office Free to get the installer for your device.
  2. 2. Open the workbook in WPS Spreadsheets: Launch WPS Office, click Spreadsheets, and use File > Open to open the Excel 2019 workbook you need to review.
  3. 3. Save or export the workbook: Click Menu > Save As and choose .xlsx or .xls format to create a copy that can be opened in Excel 2013 or shared with other users.
Opens and saves Excel .xlsx and .xls files for cross-version spreadsheet sharing.Free, lightweight, and easy to install on Windows, macOS, Android, and iOS.Includes WPS Spreadsheets with a familiar ribbon interface, formulas, and charts.Lets you review and edit workbook content when you do not have Excel 2013 available.
microsoft office alternative - wps office

Frequently Asked Questions

Why does TEXTJOIN still work in Excel 2019 Compatibility Mode but not in Excel 2013?

Compatibility Mode keeps the Excel 2019 calculation engine, so it can still calculate functions such as TEXTJOIN. Excel 2013 does not include TEXTJOIN, so the same workbook may show #NAME? or another error. Open the file in Excel 2013 to confirm actual behavior.

Does saving as .xls guarantee that my workbook will work in Excel 2013?

No. Saving as .xls runs the Compatibility Checker and can warn about unsupported formulas, objects, formatting, and macros, but it does not remove every newer feature or fully emulate Excel 2013. Click Find in the Compatibility Checker, review each issue, and test the saved file in Excel 2013.

Where do I find the Compatibility Checker in Excel 2019?

Click File > Info > Check for Issues > Check Compatibility, or save the workbook as Excel 97-2003 Workbook (*.xls). In the Compatibility Checker dialog, click Find to go to affected cells or features.

What should I check before sending an Excel 2019 workbook to an Excel 2013 user?

Review formulas for newer functions such as TEXTJOIN, CONCAT, IFS, MAXIFS, and dynamic array formulas. Press Alt+F11 to check macros, inspect charts and formatting, and then open the workbook in Excel 2013 to verify compatibility.

Can WPS Office replace Excel 2013 compatibility testing?

WPS Office can open and save Excel .xlsx and .xls files, but it does not reproduce Excel 2013's exact calculation engine. Use WPS Spreadsheets for editing and format conversion, and still verify in Excel 2013 if exact compatibility is critical.