With a corrupted Excel workbook, the original file is evidence. Make a duplicate first, test repair on the duplicate, and keep notes on which copy came from which folder or backup.
First move: For a corrupted Excel workbook, make an untouched archive copy, then run repair only on a duplicate.
Start by preserving the evidence
Treat the first few minutes like evidence handling. Keep the folder unchanged, avoid cleanup utilities, and note the app, device, account, folder, and rough time of the last good edit.
A short record prevents duplicate guessing. The last app, account, and edit time tell you whether to start with AutoRecover, version history, Trash, backup snapshots, or copy-first repair.
Work outward from the last known copy
Use the last edit location as the map. The first places worth checking are:
File > Info > Manage Workbook > Recover Unsaved WorkbooksFile > Info > Version Historyfor OneDrive or SharePoint workbooks- Excel AutoRecover location from
File > Options > Save - Copy workbook candidates before enabling repair or recalculation
Before opening a candidate, duplicate it and add the source to the filename. That small label prevents a confusing pile of almost-identical documents.
Compare copies, not originals
- Sort candidates by modified time, then by file size.
- Copy each likely file into the holding folder.
- Open copies read-only when the app allows it.
- Compare the first page, the last edited section, and any formulas, comments, or images that matter.
- Restore only after the best copy is clear.
This extra copy step is what keeps a reversible mistake reversible. If one candidate opens badly, you still have the untouched source. If two versions both contain useful work, you can compare instead of choosing blind.
The exact order for this situation
With Office, do not let the local sync folder make the decision alone. The desktop app, AutoRecover location, and browser version history can each hold a different clue.
A short session should end with at least one labeled copy outside the risky location. That gives you something to compare even if the next step needs IT.
A realistic recovery sequence
The file opens with an error after a crash. Make two copies: one untouched archive and one working copy. Try the built-in repair on the working copy, then compare file size and visible content. If the first repair produces blank pages or broken formulas, stop using that result and return to the untouched copy.
How to choose the next recovery move
| What you see | Best first check | Risk to avoid |
|---|---|---|
| The app crashed before a save | AutoRecover, unsaved files, and temp locations | Reopening and saving a blank replacement |
| The file was deleted from a synced folder | Web Trash or recycle bin for the cloud service | Letting the synced deletion become the only story |
| The content is older than expected | Version history and downloaded copies | Restoring over the live file before comparing |
| The file opens with errors | Duplicate first, repair only the duplicate | Damaging the only original with repeated repair attempts |
| Search finds many odd names | Sort by date, extension, and size | Opening every result and accidentally saving changes |
What makes recovery harder
- Restoring the first visible result because the filename looks right.
- Trusting Recent files instead of checking the actual storage location.
- Opening candidates directly from a temp folder and then saving over them.
- Running third-party recovery tools before copying cloud and backup evidence.
- Waiting until cloud Trash, version history, or backup retention windows expire.
When more attempts become risky
Stop if the missing workbook is legally important, business-critical, the only copy of a major project, or stored on a drive that is making noise or disconnecting. Also stop if every repair attempt makes the file smaller or less readable. At that point, a clean handoff with copied candidates and notes is more valuable than another random tool.
Document the candidates you found
A professional handoff is easier when the clues are labeled. Record the source of each candidate and the reason it looked promising.
This record helps even when the recovery works. If the restored workbook later turns out to be incomplete, you can return to the candidate list instead of starting over. It also makes a professional handoff cleaner because the next person can see what was already checked and which version looked strongest.
Sources and further reading
- Microsoft Support: recover Office files
- Microsoft Support: view previous versions of Office files
- Google Drive Help: find or recover a file
The point to remember
A good recovery session keeps options alive. Copy candidates, label the source, compare calmly, and restore only when the best version is obvious.