A lost Excel spreadsheet is rarely gone for good. Excel and Windows both keep hidden backups of open documents, so before retyping a payroll sheet or rebuilding an inventory list from memory, it’s worth working through the recovery options below in order. Most people find their file within the first two or three steps.
Check the Document Recovery panel
When Excel closes unexpectedly, whether from a full crash or a computer restart mid-edit, the program is usually already working to save progress in the background. Opening a blank spreadsheet right after a crash is the fastest way to find it.
- Step 1: Open a new, blank Excel workbook.
- Step 2: Watch the left side of the screen. A panel labeled “Document Recovery” should appear on its own.
- Step 3: Find the file in the list, click the version with the most recent timestamp, then go to File > Save As to store it somewhere permanent.
Recover unsaved workbooks
Closing a file and clicking “Don’t Save” by mistake is one of the more common ways a spreadsheet disappears. Excel anticipates this and quietly stores a copy anyway, using AutoRecover, a background feature that periodically saves a temporary version of an open file so it can be restored later.
- Step 1: Open Excel, click File in the top left corner, then choose Info.
- Step 2: Click Manage Workbook, then select Recover Unsaved Workbooks.
- Step 3: A folder opens. Click the “Date Modified” column to sort the files with the newest at the top.
- Step 4: Open the most recent draft. If it’s the missing file, go to File > Save As to keep a permanent copy.
Search the AutoRecover folder directly
If the first two methods come up empty, the file might still be sitting in a hidden AutoRecover folder on the hard drive. Microsoft’s documentation on the Auto-Recover feature explains how the timed saves work, and the folder itself can be reached directly.
- Step 1: Press the Windows key and R together to open the Run box.
- Step 2: Paste in
%AppData%\Microsoft\Exceland hit Enter. - Step 3: Sort the files by date modified, newest first.
- Step 4: Open each candidate file until the missing draft turns up, then save it to a normal folder with File > Save As.
Use Version History
Spreadsheets saved to OneDrive or SharePoint carry a built-in history of every saved version, which comes in handy when a formula gets overwritten or several days of edits vanish at once. Storing files in the cloud raises its own security considerations worth understanding, but for recovery purposes it’s one of the most reliable tools available. Microsoft’s guide to restoring OneDrive file versions covers the process across devices in more detail.
- Step 1: Open the spreadsheet in Excel.
- Step 2: Click the file name at the top of the screen and select “Version History” (also found under File > Info > Version History).
- Step 3: A panel opens on the right listing every previous save. Click through them to preview each one.
- Step 4: Found the right one? Click Restore to bring it back.
Check previous folder versions with File History
Computers with Windows File History turned on take regular snapshots of entire folders, not just individual files, which makes it worth checking even after a file has been fully deleted. Microsoft’s guide walks through setup and recovery step by step.
- Step 1: Open File Explorer, find the folder where the spreadsheet used to live, right-click it, and choose Properties.
- Step 2: Click the “Previous Versions” tab.
- Step 3: Choose a folder version dated before the file went missing, then click Open.
- Step 4: A window shows exactly what that folder looked like on that date. Find the spreadsheet, copy it, and paste it into the current folder.
Search the temporary files folder
As a last resort, fragments of a spreadsheet sometimes end up in the Temp folder, a holding area where Windows stores leftover data from programs while they run.
- Step 1: Press Windows key + R, type
%temp%, and hit Enter. - Step 2: In the search bar, type
*.tmpand sort by date. If nothing useful appears, search~$*instead. - Step 3: Look for files created around the time the spreadsheet disappeared. Right-click one, choose Open With, and select Excel.
- Step 4: If the missing data appears, copy it into a new spreadsheet immediately and save it.
Pro tip: A 30-second setting change now can prevent this entire scramble later.
- Open Excel and go to File > Options > Save.
- Find “Save AutoRecover information every 10 minutes” and change the 10 to a 2.
- Confirm the box below it, “Keep the last AutoRecovered version if I close without saving,” is checked.
Saving business documents to a cloud service such as OneDrive adds another layer of protection, since it backs up changes automatically as they’re typed. Even reliable providers have off days though, and a look back at recent cloud outages makes the case for backing up more than one way. It’s also worth treating a missing spreadsheet as a small warning sign rather than a one-off scare. Our guide on defending against data loss covers six strategies worth putting in place, and the truth about disaster recovery looks at where most recovery plans quietly fall apart. If spreadsheets sit at the center of daily operations, they belong in a documented business continuity plan, not just in the hope that AutoRecover catches everything.
CyberJaz works with small and medium businesses across the Pittsburgh area to build backup and recovery systems that catch problems like this before they cost a full day of work.
Frequently asked questions
Where does Excel store AutoRecover files by default?
In %AppData%\Microsoft\Excel on Windows. The Document Recovery panel checks this folder automatically, but it can also be opened directly through File Explorer.
Can a spreadsheet be recovered after Excel has been closed for days?
It depends on the method. AutoRecover files are usually cleared out after a short window, but Version History on OneDrive or SharePoint keeps saved copies going back much further, and File History can reach even older snapshots if it’s been enabled.
Does OneDrive save spreadsheet changes automatically?
Yes. Files saved to OneDrive or SharePoint use AutoSave, which stores changes in real time rather than at fixed intervals, and every save creates a new entry in Version History.
What’s the difference between AutoSave and AutoRecover?
AutoSave continuously saves files stored in OneDrive or SharePoint as changes happen. AutoRecover, available in every version of Excel, saves a temporary local copy at set intervals so a file can be restored after a crash, even when it isn’t stored in the cloud. Microsoft’s overview of recovering earlier file versions covers both features side by side.
For businesses that want backup and recovery built into daily operations rather than pieced together after a scare, reach out to our IT experts today.
