If Excel closed before you saved, open Excel, go to File, Open, Recent, and press Recover Unsaved Workbooks at the bottom of the list. If you saved over good data, check File, Info, Version History for a cloud file, or right-click the file in Windows and look for Previous Versions. The key move in every case: stop editing the damaged file until you have tried these.
What should I do in the first minute?
- Do not keep saving. Each save can push an older recoverable version out of the way.
- If Excel crashed, reopen it. A Document Recovery pane often appears on the left with the files it rescued; pick the latest one and use Save As with a new name.
- If you accidentally overwrote the file, do not reopen and re-save it. Note the time you last had good data; you will need it to choose the right version.
- Look at the file name in the title bar. Is it a cloud file or a local one? The route differs.
Where is the AutoRecover folder?
Excel keeps temporary copies while you work if AutoRecover is on. To see where, open File, Options, Save. The box shows how often it saves recovery information, a tick for keeping the last autosaved version if you close without saving, and the AutoRecover file location. Copy that path, paste it into File Explorer, and look for a folder named after your workbook. Files recovered from here are best opened and then saved under a fresh name straight away.
If the interval shown is long, shorten it. Writing recovery data every few minutes costs very little on a small expense workbook.
How do I use version history for a cloud file?
For a workbook stored on OneDrive or SharePoint, open File, Info, Version History. A panel lists earlier versions with dates and times. Open one, compare it with the current file, and press Restore if it is the one you want. You can also open the OneDrive website, right-click the file and choose Version history. In Google Sheets, use File, Version history, See version history, which shows who changed what and when.
| Situation | First place to look | Backup plan |
|---|---|---|
| Closed without saving | File, Open, Recent, Recover Unsaved Workbooks | AutoRecover folder |
| Excel froze or crashed | Document Recovery pane on reopening | AutoRecover folder |
| Saved over good data, cloud file | Version History in Excel or on the cloud website | Another backup copy |
| Saved over good data, local file | Right-click file, Properties, Previous Versions (if Windows has it on) | Your scheduled backup |
| File deleted | Recycle Bin, then cloud recycle bin | Your scheduled backup |
What if the file is local and there is no previous version?
Previous Versions only exist if Windows File History or restore points were switched on earlier. If they were not, check whether you e-mailed the file to yourself, saved a copy to a pen drive, or have a copy in a phone backup. Also check your statements: if the workbook was built from monthly bank PDFs or CSVs, those are safe in your downloads and can rebuild the sheet.
Say you lost three weeks of entries. Rebuilding from statements might take an hour; rekeying from memory would take longer and be less accurate. This is where saved originals pay off.
How do I stop it happening again?
- Keep the workbook in a cloud folder with AutoSave and version history on.
- Keep one scheduled or manual copy per month-end on a separate drive.
- Protect formula cells so a stray overwrite cannot replace a calculation.
- Name a version before any large clean-up.
If recovery has become a recurring worry, it may be worth keeping the source data in a tracker. SpendixAI stores imported transactions in your workspace, and deleted transactions go to a recycle bin for 30 days, which covers a different kind of mistake from a lost spreadsheet.
Useful ideas start with a clearer picture of your own spending.
Explore your reports


