Fix Excel 365 Workbooks That Will Not Open in Older Excel Versions
Question details
The user needs to troubleshoot a macro-enabled workbook created in Microsoft 365 that fails or closes when opened in Excel 2019 or an earlier version.
- Product
- Microsoft Excel macro-enabled workbook
- Device & OS
- not provided
- Scenario
- A workbook created or updated in Microsoft 365 must be opened and used in Excel 2019 or earlier.
- Observed behavior
- The workbook closes, fails to open, or does not work correctly in the older Excel version.
Identify every target Excel version and confirm whether the workbook requires macros, newer formulas, or other Microsoft 365 features. Keep the original file unchanged while testing compatible copies in each target version.
Check workbook features and save it in a compatible Excel format
Use this approach when the file opens in Microsoft 365 but fails in an older Excel release because of unsupported features or file-format differences.
Microsoft 365 can introduce formulas, objects, and features that are unavailable in older Excel versions. Saving as Excel 97–2003 Workbook (*.xls) may improve compatibility, but it can remove or alter features and macros, so confirm that the workbook still meets your requirements after conversion.
In Microsoft 365 Excel, open the workbook and select File > Info > Check for Issues > Check Compatibility. Review each reported feature and follow the suggested correction.
Select File > Save As, choose an appropriate format such as Excel Macro-Enabled Workbook (*.xlsm) or Excel 97–2003 Workbook (*.xls), and save a separate test copy. Do not choose .xlsx if the workbook must retain VBA macros.
Replace formulas, charts, connections, controls, or other objects marked as unsupported in the Compatibility Checker with features available in the oldest target Excel version.
Open the test copy in Excel 2019 and each earlier target version, then check formulas, buttons, external links, data connections, and macro behavior.
Update the older Excel installation and debug VBA references
Use this solution when the workbook format is appropriate but Excel still closes, displays errors, or fails while running macros.
Use WPS Office to Open and Test Compatible Excel Workbooks
WPS Office is a free, lightweight Microsoft Office alternative with a familiar spreadsheet interface and support for common Excel formats. It can help you open, review, edit, and test compatible workbook copies while migrating away from version-specific Excel installations, although complex VBA projects and Microsoft 365-only features may require Microsoft Excel.
Frequently Asked Questions
Why does an Excel 365 workbook fail in Excel 2019 or earlier?
The workbook may contain Microsoft 365-only formulas, unsupported objects, newer data features, incompatible external connections, or VBA references that the older Excel version cannot load. Use File > Info > Check for Issues > Check Compatibility in Microsoft 365 Excel to identify likely causes.
Should I save the workbook as .xls to make it open in older Excel?
Save as Excel 97–2003 Workbook (*.xls) only when the workbook does not depend on features unavailable in that format. The conversion can remove newer formulas, reduce worksheet capacity, and affect macros, so test the converted copy in every target version.
Can an .xlsx file preserve Excel macros?
No. The .xlsx format does not store VBA macros. Use Excel Macro-Enabled Workbook (*.xlsm) to retain macros in Excel 2007 and later, and verify that the VBA code uses references and objects supported by the target version.
How do I fix a missing VBA reference in an older version of Excel?
Press Alt+F11, select Tools > References in the Visual Basic Editor, locate entries marked MISSING, and clear or replace them with libraries installed on the target computer. Then select Debug > Compile VBAProject and correct any remaining errors.
Will WPS Office run every Excel VBA macro?
No. WPS Office supports many common Excel formats, but complex VBA projects, ActiveX controls, external connections, and Microsoft 365-specific features may not work identically. Test a copy of the workbook and use Microsoft Excel when exact VBA compatibility is required.
