How to Recover an Unsaved Excel File
If Excel crashed or closed before you saved, open it again. Excel for Microsoft 365 checks for AutoRecover files at startup and lists any it finds in the Document Recovery pane. If no pane appears, select File > Info > Manage Workbook > Recover Unsaved Workbooks, open the latest file, and save it under a new name.
Try these quick fixes first
- Close every Excel window, start Excel again, and check for the Document Recovery pane.
- Select File > Info > Manage Workbook > Recover Unsaved Workbooks.
- For a workbook in OneDrive or SharePoint, select the file name at the top of the window, then Version history.
- Type the workbook’s name into Search on the taskbar.
- Open the Recycle Bin and look for the file.
- On a Mac, open Excel again and save anything it recovers before you close it.
Reopen Excel and use Document Recovery
When Excel closes unexpectedly, it opens Document Recovery the next time it starts, so restarting it is the first thing to try.
- Close any Excel windows that are still open, then start Excel again.
- If the Document Recovery pane appears, read the date and time under each file name. When a workbook is listed more than once, the latest time usually holds your newest changes.
- Select a file to open it, or select the arrow next to it and choose Save As.
- Save it as an .xlsx file with a new name, so it can’t replace an older copy you may still need.
- When you’re done, select Close. If you aren’t sure you kept everything, choose Yes, I want to view these files later (safest option).
Use Recover Unsaved Workbooks
When Keep the last AutoRecovered version if I close without saving is turned on, Excel keeps the last AutoRecover copy of a workbook you closed without saving.
- Start Excel and open a blank workbook or any existing one.
- Select File > Info > Manage Workbook > Recover Unsaved Workbooks.
- Pick the file that matches the time you were working, then select Open.
- In the bar across the top of the workbook, select Save As and save it where you’ll find it again.
- If the workbook had been saved at least once, open it and select File > Info. Under Manage Workbook, select the version labeled (when I closed without saving), then select Restore in the bar at the top. Restore overwrites the version you saved earlier, so use Save As instead if you want to keep both.
Check the AutoRecover file location
Excel writes recovery copies to folders on your PC that you can open yourself when nothing shows up in Excel.
- In Excel, select File > Options > Save and copy the path in the AutoRecover file location box.
- Open File Explorer, paste the path into the address bar, and press Enter.
- Also look in
C:\Users\<UserName>\AppData\Local\Microsoft\Office\UnsavedFiles, where Office keeps files closed without saving. Replace <UserName> with your Windows user name. - Open the newest item that matches your workbook’s name or the time you were working, then save it right away as a new .xlsx workbook.
Search your PC for the workbook
A workbook that seems lost has sometimes been saved after all, just to a folder you didn’t expect, so search before you rebuild it.
- Select Search on the taskbar, type the workbook’s name or a word from it, and select the Documents tab. Results cover your PC and OneDrive.
- If that doesn’t find it, open File Explorer, select This PC, and type the name in the search box at the top right. This search is slower but looks in more places.
- If you don’t remember the name, search for
*.xlsxto list your workbooks, and look for one changed on the day you lost it. - Right-click a match and select Open file location to see where it was saved.
Restore an earlier version with Version History
Workbooks stored in OneDrive or SharePoint are saved every few seconds by AutoSave, and Microsoft 365 keeps earlier versions you can reopen.
- Open the workbook from OneDrive or SharePoint.
- Select the file name at the top of the Excel window, then select Version history.
- Select a version from the list. It opens in a separate window.
- To make that version the current one, select Restore.
On a Mac, select the workbook name in the title bar, then Browse Version History. With a work or school account, how many versions you can see depends on how the library is set up.
Check the Recycle Bin and OneDrive recycle bin
If the workbook was deleted rather than never saved, a recycle bin may still have it.
- Open Recycle Bin from the desktop.
- Look for the workbook’s name. If you can’t remember it, look for files ending in .xlsx or .xls.
- Right-click the file and select Restore. It goes back to the folder it was deleted from.
- Files deleted from OneDrive or SharePoint online, including online-only files, never reach your computer’s Recycle Bin. For OneDrive, open the OneDrive website, select Recycle bin in the navigation pane, select the file, and select Restore.
On a Mac, open the Trash, right-click the workbook and select Put Back. For SharePoint files, follow our guide to recovering deleted files from OneDrive or SharePoint.
How to recover unsaved Excel files on a Mac
Excel for Mac reopens recovered workbooks by itself after a crash, and it stores AutoRecover copies in a hidden folder you can reach from Finder.
- Open Excel again. If it brings back your workbook, save it before you edit or close it. A recovered file you close without saving is deleted.
- If nothing comes back, open Finder and select Go > Go to Folder, or press Shift + Command + G.
- Enter
/Users/<username>/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft, replacing <username> with your Mac user name. - Open the file that matches the date and time you were working, then save it under a new name.
If you chose Don’t Save when you closed the workbook, Excel for Mac removes its AutoRecover copy. Try Version History or the Trash instead.
Turn on AutoSave and AutoRecover so it doesn’t happen again
AutoSave saves workbooks in OneDrive or SharePoint as you work, and AutoRecover protects workbooks stored on your PC between saves.
- Save new workbooks to OneDrive or SharePoint with File > Save As, then make sure the AutoSave switch at the top left is on. AutoSave needs a Microsoft 365 subscription.
- Use the .xlsx format. AutoSave doesn’t work with older .xls files or with CSV files.
- Select File > Options > Save.
- Under Save workbooks, check Save AutoRecover information every and enter a short interval, such as 5 minutes.
- Check Keep the last AutoRecovered version if I close without saving.
- Make sure Disable AutoRecover for this workbook only is cleared, then select OK.
In Excel for Mac, you can turn AutoRecover on or off under Excel > Preferences > Save, but Excel picks the interval itself. AutoRecover is a backup, not a substitute for saving, so press Ctrl+S (Command+S on a Mac) often.
Why does this happen?
- Excel or Windows shut down unexpectedly: a crash, a frozen workbook, an update restart, a power cut or a dead battery.
- Someone selected Don’t Save when closing the workbook.
- The workbook was stored on the PC or a file server instead of OneDrive or SharePoint, so AutoSave wasn’t running.
- The file was a CSV or an older .xls workbook, which AutoSave doesn’t support.
- AutoRecover was off, set to a long interval, or disabled for that workbook.
- The workbook was saved to an unexpected folder, or deleted.
When should you call IT?
- The workbook lived on a shared network drive or file server. IT may be able to restore it from a backup.
- Version History for a OneDrive or SharePoint workbook is missing or shorter than expected. Your organization’s library settings decide how many versions are kept.
- The AutoSave switch never appears, even for workbooks in OneDrive. Your administrator may control which version of the Microsoft 365 apps you have.
- You need a workbook that was permanently deleted. Use the computer as little as possible until IT looks at it, because Microsoft notes that any new files can overwrite the space a deleted file used.
- The computer makes clicking noises, reports disk errors or won’t start. Stop using it.
- Many files disappeared at once, or were renamed with odd extensions. Treat that as a possible security incident.
For help with OneDrive, SharePoint and AutoSave across your team, see our Microsoft 365 support page.
OAC Technology’s IT support team fixes problems like this for businesses across the Twin Cities. Clients can call 952-548-5558, Monday to Friday, 8 a.m. to 6 p.m. Central. Not a client yet? Call the same number or send us a message.
Common questions
Where does Excel save unsaved files?
On Windows, Excel keeps AutoRecover copies in the folder named under File > Options > Save > AutoRecover file location, and workbooks closed without saving in C:\Users\<UserName>\AppData\Local\Microsoft\Office\UnsavedFiles. On a Mac, they’re in a hidden folder inside Library/Containers/com.microsoft.Excel in your user folder.
Can I recover an Excel file after clicking Don’t Save?
Yes on Windows, if AutoRecover had saved a copy and Keep the last AutoRecovered version if I close without saving was on. Go to File > Info > Manage Workbook > Recover Unsaved Workbooks. On a Mac, Don’t Save deletes the AutoRecover copy, so check Version History or the Trash.
How can I recover an Excel file that was autosaved?
If AutoSave was on, your changes are already saved in OneDrive or SharePoint. To get back an earlier state, select the file name at the top of the window, then Version history, open the version you want, and select Restore.
What if a recovered workbook won’t open?
Try Excel’s Open and Repair. Select File > Open, browse to the workbook, select it, then select the arrow next to Open and choose Open and Repair > Repair. If that fails, choose Extract Data to pull out its values and formulas.









