A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Try these steps in order:
- Repair the workbook itself.
- Open Excel.
- Select File > Open.
- Browse to the workbook.
- Select the file.
- Select the arrow next to Open.
- Select Open and Repair.
- First choose Repair.
- If that does not work, choose Extract Data to recover values and formulas.
- If the problem happens with many Excel files, repair Office.
- On Windows, open Settings > Apps.
- Find the Office app.
- Select it, then choose Modify.
- Run Online Repair.
- If Excel opens but shows a blank screen instead of the file:
- In Excel, go to View > Unhide.
- Or minimize Excel and then maximize it again.
- If double-clicking files opens Excel incorrectly, reset the file association.
- Right-click the file.
- Select Properties.
- Next to Opens with, select Change.
- Choose Excel and enable Always use this app.
- If Excel shows a message that the file format or extension is not valid:
- Make sure the file came from a trusted source.
- If the file extension was renamed by mistake, open it and save it again with the correct Excel format.
- If the workbook is corrupted, use Open and Repair.
- If Excel hangs and asks to grant access to files, update Excel.
- This issue was fixed in version 16.34 and later.
If the workbook became corrupted while editing and was not saved correctly, reopen the workbook from File > Open, double-click it, and choose Yes to revert to the last saved version.
References:
- Repair a corrupted workbook
- Repairing a corrupted workbook
- Double-clicking an Office file fails to open it in the correct Office program
- Troubleshoot opening a blank screen when you double-click a file icon or file name in Excel
- A file is in a different format than its extension indicates in Excel
- Excel prompts you to grant access to files and then hangs or shows a warning that it cannot open the .xlsx file because the format or extension is not valid