Every IT helpdesk has the same call at least once a month: someone closed an Excel workbook without saving and lost the morning's work, or a file went missing from the shared drive, or a workbook corrupted itself and won't open. These are recoverable situations — usually — if you know where Excel hides its safety nets. Here are the six tricks every business user should know, plus the harder truth at the end about why none of them substitute for a real backup strategy.
1. Check the Document Recovery panel
When Excel crashes or Windows reboots unexpectedly, Excel tries to auto-save your in-progress work to a recovery file. Reopen Excel and the Document Recovery pane appears on the left. Pick the file with the most recent timestamp and save it somewhere safe before doing anything else.
2. Recover unsaved workbooks via File → Info → Manage Workbook
If you closed a never-saved workbook by accident, Excel keeps a hidden cache. Open Excel, File → Info → Manage Workbook → Recover Unsaved Workbooks. Sort by Date Modified, pick the most recent draft, and save it properly.
3. Find AutoRecover files in your AppData folder
If Excel itself can't surface a recovery file, you can still browse the directory it uses: press Windows+R, paste %AppData%MicrosoftExcel, hit Enter. The folder may contain partial saves Excel didn't auto-detect. Sort by date modified — newest first — and try opening anything from the right time window.
4. Use Version History (Microsoft 365 / OneDrive / SharePoint)
If your file lives in OneDrive or SharePoint — which it should — Excel keeps a version history automatically. Right-click the file in Explorer or in the SharePoint web view, choose Version History, and restore any prior version with one click. This works even if the file was overwritten with garbage or accidentally deleted (the Recycle Bin in SharePoint retains deleted files for 93 days).
5. Open and Repair on a corrupted file
If a workbook won't open or throws errors, Excel has a repair mode: File → Open → browse to the file, then click the dropdown arrow next to the Open button and choose "Open and Repair." Excel will try to recover the data, even from partially damaged files. Worst case, you can extract values without formatting.
6. Restore from the previous-versions Windows feature
For files on a local drive (not the right place for important business data, but reality is reality), Windows' File History or system restore can sometimes surface older versions. Right-click the file → Properties → Previous Versions. If File History is enabled and the file was on a watched folder, older copies appear here.
Why these six aren't a backup strategy
Every one of these tricks has the same shape: Microsoft, Windows, or the cloud provider made an opportunistic copy on your behalf, and you're hoping the copy is the right one. None of these are deliberate backups. None of them are tested. None of them protect you against the failure modes that actually take businesses down — ransomware that encrypts the file and every version of it, accidental deletion by a departing employee that aged out of the 93-day window, or a corrupt OneDrive sync that overwrites the good copy with garbage on every device.
For a business, the real safety net looks like:
- Third-party backup of Microsoft 365. Microsoft doesn't back up your tenant beyond the Recycle Bin window. A dedicated M365 backup service (Veeam, Datto, Acronis, or similar) captures all your SharePoint, OneDrive, Exchange, and Teams data with 1-year+ retention and granular point-in-time restore.
- Tested restores on a real cadence. A backup that has never been restored is a hope, not a plan. Quarterly restore tests prove the backup actually works.
- Written Recovery Time Objectives. How long can you be down before the business takes real damage? That number should be documented per system and matched to your actual backup architecture.
- Immutable backups for ransomware protection. Modern ransomware groups specifically target backup infrastructure. Immutable (write-once, retention-locked) backups can't be encrypted even by a domain admin account.
This is what our Business Continuity service covers — for Utah and Tennessee businesses that don't want to find out their backup didn't work on the day they need it.
If your business's last test-restore of a critical file or system was "I'm not sure," that's the call to have. Book a 30-minute scoping conversation and we'll tell you what your real exposure looks like.