Excel Cannot Open XLSX File After a Mac Update? How to Fix It
Question details
The user needs to troubleshoot an Excel error on Mac that prevents opening an XLSX workbook because the file format or file extension is reported as invalid, possibly after a macOS update.

- Product
- Microsoft Excel for Mac
- Device & OS
- macOS
- Scenario
- Opening an existing .xlsx workbook in Excel after a macOS update.
- Observed behavior
- Excel shows an error that the file cannot be opened because its format or file extension is invalid, and the workbook will not open.
Locate the original XLSX file in Finder, confirm the file name ends in .xlsx, and make a copy before attempting any repair so you do not overwrite the only version.
Open and Repair the XLSX File with WPS Spreadsheet
Use this solution when Excel refuses the file due to a format or extension error; WPS Spreadsheet can often open and recover the workbook data.
WPS Spreadsheet reads the same .xlsx file package as Excel and can often bypass workbook-level corruption that triggers Excel's format or extension error on macOS.
Launch WPS Office on your Mac and open WPS Spreadsheet from the home screen.
Click Menu > Open, locate the affected .xlsx file in Finder, and select it.
If WPS Spreadsheet detects a damaged workbook, click Repair in the recovery prompt and wait for the file to load.
Click Menu > Save As, choose Excel Workbook (.xlsx), and save the file with a new name to create a clean copy.

Use Open and Repair in Microsoft Excel for Mac
Try this when you prefer to remain in Microsoft Excel and the file is not severely corrupted.
Recover the Workbook from a Backup or Version History
Use this solution if the current file is too damaged to open or repair.
Open and Repair XLSX Files After a Mac Update with WPS Spreadsheet
Use WPS Spreadsheet on Mac to open, repair, and save the affected XLSX workbook without Microsoft Excel. WPS preserves Excel compatibility and helps you recover data when Excel reports an invalid format or extension.
- 1. Download and install WPS Office: Download WPS Office Free from the official WPS website, install it on your Mac, and launch WPS Spreadsheet.
- 2. Open the affected XLSX file: In WPS Spreadsheet, click Menu > Open, locate the .xlsx file in Finder, and select it.
- 3. Use Repair if prompted: If WPS detects a damaged workbook, click Repair when the recovery prompt appears, then wait for the file to load.
- 4. Save a recovered copy: Click Menu > Save As, choose Excel Workbook (.xlsx), and save the file with a new name to preserve a clean copy.

Frequently Asked Questions
Why does Excel say the XLSX format or extension is invalid after a Mac update?
It usually means the file is corrupted, has an incorrect extension, was not fully downloaded, or the update affected how Excel reads the workbook package. First verify that the file name ends in .xlsx and try opening it from Excel's Open dialog.
Can WPS Office open an XLSX file that Excel cannot open?
Yes. WPS Spreadsheet can often open and repair XLSX files that Excel rejects. Open WPS Spreadsheet, click Menu > Open, select the file, and use Repair if prompted.
How do I use Open and Repair in Microsoft Excel on Mac?
In Excel, go to File > Open, select the XLSX file, click the arrow next to Open, and choose Open and Repair.
Will repairing an XLSX in WPS change my Excel formatting?
WPS preserves worksheets, formulas, and most Excel formatting. After recovery, save the file as an Excel Workbook (.xlsx) and review complex charts, macros, or conditional formatting.
What should I do if neither Excel nor WPS can open the file?
Restore a previous version from macOS Time Machine, OneDrive, SharePoint, or another backup. If no backup exists, contact Microsoft Support for workbook recovery options.




