MAPICan Excel Repair a Corrupted Workbook?
A corrupted workbook is different from an unsaved workbook: the file exists, but Excel cannot open or interpret it normally. Microsoft provides built-in repair and recovery tools, yet the outcome depends on which parts of the file are damaged and whether a usable earlier version or backup exists.
It depends. Excel can automatically try File Recovery when it detects corruption, and you can also use Open and Repair manually. If Repair cannot recover the workbook, Excel may still be able to extract values and formulas, but some formatting, features, or data can be lost.
depends
The answer
Excel can sometimes repair a corrupted workbook, but it cannot guarantee a complete recovery. It may start File Recovery automatically when corruption is detected, or you can select Open and Repair manually. If Repair fails, the Extract Data option may still recover values and formulas from the workbook.
Why
Microsoft's repair workflow is designed to salvage as much workbook data as possible. File Recovery can start automatically when Excel recognizes corruption. If that does not happen, Open and Repair provides a manual attempt. Microsoft then offers two choices: Repair, which tries to recover the workbook more completely, and Extract Data, which focuses on values and formulas when a normal repair cannot succeed. If the workbook is stored in OneDrive or SharePoint and version history is available, restoring an earlier healthy version can also be useful. None of these methods guarantees that every object, format, formula, macro, connection, or recent change will survive.
When it is usually OK
- Excel detects corruption and starts File Recovery automatically.
- The file can be selected through File > Open and processed with Open and Repair.
- The damaged workbook still contains recoverable workbook structures or cell data.
- An earlier healthy version exists in OneDrive or SharePoint version history.
- A backup or recovery copy exists from before the corruption occurred.
When you should not
- The file is physically unreadable because the storage device itself has failed.
- The workbook content has been overwritten or truncated beyond what Excel can reconstruct.
- Repair succeeds only partially and critical workbook objects are missing.
- There is no backup, previous version, or recoverable data remaining in the file.
- The issue is actually an unsupported or incorrect file extension rather than ordinary workbook corruption.
Risks and exceptions
- A repaired workbook may lose formatting, formulas, charts, links, macros, or other features depending on the damaged content.
- Extract Data is intended to salvage values and formulas, not necessarily preserve the workbook exactly as it was.
- Restoring a previous version can discard edits made after that earlier version.
- Repeatedly saving over the only copy of a damaged workbook can reduce your ability to compare recovery attempts.
Best practice
Work on a copy of the corrupted file whenever possible. Try Excel's built-in File Recovery or Open and Repair first. If Repair fails, try Extract Data. For files stored in OneDrive or SharePoint, check Version History for a known-good copy before making destructive changes to the only available file.
Alternatives
- Restore an earlier version from OneDrive or SharePoint when version history is available.
- Recover from a backup copy.
- Try extracting values and formulas when full repair fails.
- Move the file from a problematic network or storage location to a healthy local drive before attempting recovery, as Microsoft recommends for disk or network errors.
Frequently asked questions
What is Open and Repair in Excel?
It is a built-in Excel option available from the Open dialog that attempts to repair a corrupted workbook or extract data from it.
What does Extract Data recover?
Microsoft says Extract Data can retrieve values and formulas when the normal Repair option cannot recover the workbook.
Can Excel restore a previous version of a corrupted workbook?
If the file is stored in OneDrive or SharePoint with version history available, you may be able to restore an earlier version.
Is a corrupted workbook the same as an unsaved workbook?
No. A corrupted workbook is an existing file that Excel cannot read normally, while an unsaved-work issue concerns edits or files that were not successfully saved.
Sources
- Repair a corrupted workbook — Microsoft SupportOfficial
- Restore a previous version of an Excel file — Microsoft SupportOfficial
Written by Mapiance Editorial Team
The Mapiance Editorial Team researches, writes, reviews, and maintains practical guides and explainers for MAPIANCE.
Reviewed by Mapiance Editorial Team
Published Sep 4, 2026 · Updated Sep 21, 2026 · Verified Sep 1, 2026