Issue with opening of MS Excel file

Use Extract Data from Excel’s Open and Repair dialog because the normal Repair attempt has already produced no result.

Recover data from this workbook

1. Create a copy of the file first and work only on the copy to avoid further changes to the original.
2. If the workbook is on a USB drive, network location, or shared folder, copy it to a local folder such as Documents before recovery; Microsoft recommends moving it locally when a disk or network error may be involved.
3. Open Excel without opening the damaged file.
4. Select File → Open → Browse. Do not select it from Recent.
5. Select the copied workbook.
6. Select the arrow beside Open, then Open and Repair.
7. Instead of choosing Repair again, select Extract Data. This attempts to recover the workbook’s values and formulas when Repair cannot recover it.^1^
8. If it opens, immediately use File → Save As and save it under a new name.

If Extract Data also fails

Try opening without recalculation:

1. Open Excel and create a Blank workbook.
2. Select File → Options → Formulas.
3. Under Calculation options, select Manual, then OK.
4. Select File → Open → Browse and try opening the damaged workbook.
5. If successful, save a new copy before changing calculation back to automatic.^1^

If the file is stored in OneDrive or SharePoint, restore an earlier version:

1. Locate the file in OneDrive, SharePoint, or the synced folder in File Explorer.
2. Right-click it and select Version history.
3. Choose a version from before the problem occurred.
4. Select its three-dot menu and then Restore.

Restoring replaces the current copy, so changes made after the selected version will not be retained.^2^

If several Excel files will not open

That points to an Excel/Office installation problem rather than damage limited to this workbook. Repair Microsoft 365:

• Windows 11: Right-click Start → Installed apps → Microsoft 365/Office → … → Modify → Online Repair → Repair.
• Windows 10: Right-click Start → Apps and Features → Microsoft 365/Office → Modify → Online Repair → Repair.

Online Repair repairs the entire Office suite and may require a computer restart.^3^

If other workbooks open normally but this one still fails after Extract Data and no earlier version exists, the available Microsoft recovery methods may not be able to reconstruct the workbook. Preserve the original file and any backup copies before considering third-party recovery software.

References

1. Repair a corrupted workbook | Microsoft Support
2. Restore a previous version of an Excel file | Microsoft Support
3. Repair an Office application