When you are looking for an unsaved Excel workbook, the first clue is usually not the Recent list. It is the gap between the last edit, the app's recovery folder, and any cloud draft that existed before the next save. Work from copies so a promising workbook can be tested without changing the source.
First move: For an unsaved Excel workbook, close replacement drafts and copy every workbook candidate into a labeled holding folder before opening it.
Freeze the recovery scene first
Pause the instinct to click around. Do not make a new file with the same name, do not clear deleted items, and do not run repair tools until the likely storage path is written down.
Those notes keep the search from becoming random. A crash points toward AutoRecover or temporary files; a cloud mistake points toward web recycle bins; an overwrite belongs in version history; a damaged file needs copy-first repair.
Check the places that still keep versions
Follow the trail from app recovery to cloud history to backups. In this case, check:
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
Keep original candidates in place until the case is closed. Work from copies with source labels so a bad open or save does not destroy the trail.
Label each recovery candidate
- 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.
A holding folder gives you room to compare. One candidate may have the newest text while another has intact formatting, comments, or slides. Do not force the decision before both are safe.
How this case usually resolves
For Office files, start with the built-in recovery trail before creating another version. Check the app recovery picker, AutoRecover path, and browser-based version history before trusting a synced desktop folder.
If time is tight, do the reversible part first: copy the current file or folder, open the web version if a cloud service is involved, and download a candidate instead of restoring over the live copy.
What this looks like in practice
A laptop restarts after a long editing session. The user opens Office, sees no useful Recent entry, and almost starts a new workbook with the same name. The safer sequence is to close the replacement, make a recovery-candidates folder, check the recovery picker, then copy any .asd, .tmp, or cloud draft before opening it. If one candidate has the last paragraph and another has the formatting, both copies are preserved for comparison.
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 |
Clicks to avoid while evidence exists
- 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.
Signs you should pause
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.
Leave a recovery note for later
Keep a small recovery log. It should name the missing file, the likely folder, the device, the service, and every candidate you copied so the next attempt does not start from zero.
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
Do not let urgency turn a recoverable mistake into an overwrite. Preserve candidates first, then decide.