How to Recover an Excel File That Was Not Saved

Losing an Excel file before saving it is one of those gut-punch moments that almost every spreadsheet user has experienced. Whether your computer crashed, Excel froze, or you accidentally clicked "Don't Save," the data isn't always gone for good. Excel and Windows both have built-in mechanisms designed specifically for this situation — and understanding how they work gives you a realistic picture of what's recoverable and what isn't.

How Excel Protects Your Work Behind the Scenes

Modern versions of Excel (2010 and later, including Microsoft 365) run a background process called AutoRecover. By default, this saves a temporary snapshot of your open workbook every 10 minutes. These snapshots are stored in a hidden system folder — not in your Documents folder — and they're separate from the file you're actively working on.

There's also a related feature called "Keep the last autosaved version." When enabled, Excel retains one recovery copy even if you close a file without saving it. This is the setting that saves you when you click "Don't Save" by mistake.

These two features work together, but they're not the same thing:

Method 1: Use Excel's Built-In Document Recovery

When Excel crashes and you reopen it, a Document Recovery pane usually appears on the left side of the screen automatically. It lists recovered versions of files that were open at the time of the crash. This is your first stop.

Click on the version you want to review. If it looks correct, save it immediately with File → Save As before doing anything else.

If the recovery pane doesn't appear, you can look for AutoRecover files manually.

Method 2: Find AutoRecover Files Manually

If Excel didn't surface the recovery pane, the temp files may still exist on your system.

In Excel:

1. Go to File → Info → Manage Workbook
2. Click "Recover Unsaved Workbooks"
3. A folder opens showing .xlsb or .xlsx temp files with generic names and timestamps

Directly on Windows: The default AutoRecover folder path is typically: C:Users[YourUsername]AppDataRoamingMicrosoftExcel

You may need to enable "Show hidden files" in File Explorer to navigate there, since the AppData folder is hidden by default.

On macOS, AutoRecover files are stored in: /Users/[YourUsername]/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

Once you find the file, open it and save it immediately to a permanent location.

Method 3: Check for Temporary Files

Windows sometimes retains temporary working files in the system's Temp folder. These aren't guaranteed to be Excel-readable, but they're worth checking if other methods come up empty.

Open the Run dialog (Win + R), type %temp%, and press Enter. Look for files with .tmp extensions or filenames that partially match your spreadsheet's name. You can try opening them directly in Excel — some will work, many won't.

Method 4: Use OneDrive or SharePoint Version History 🔄

If your file was saved to OneDrive or SharePoint at any point — even just once — Microsoft 365's AutoSave feature may have been running in the background, pushing continuous updates to the cloud.

Right-click the file in OneDrive or open it and go to File → Info → Version History. You'll see a timestamped list of saved states you can restore or download individually. This is generally the most reliable recovery path for Microsoft 365 subscribers working in the cloud.

What Affects Whether Recovery Actually Works

Not all unsaved file situations are equal. Several variables determine whether the above methods will yield anything useful:

• How long the file was open before the crash — If Excel hadn't yet run an AutoRecover cycle (i.e., less than 10 minutes had passed), there may be nothing to recover
• AutoRecover interval setting — The default is 10 minutes, but users can change this. A longer interval means more potential data loss between snapshots
• Whether AutoRecover was enabled at all — Some users or IT administrators disable it; go to File → Options → Save to verify your settings
• File type — AutoRecover works most reliably with .xlsx and .xlsm files. Older .xls formats may behave differently
• Whether the file had ever been saved once — A brand-new file that was never saved even once has fewer recovery options than an existing file that was edited and then lost
• Storage location — Files stored locally behave differently from those on network drives or cloud storage. OneDrive and SharePoint users generally have better recovery options due to continuous sync

What "Never Saved" Really Means for Recovery 💾

A file that was created, worked on, and closed without ever being saved once is the hardest scenario. Excel's AutoRecover can still capture a temp snapshot if the file was open long enough, but there's no original version to fall back on. The recovery file, if it exists, will have an auto-generated name and no meaningful file path.

In contrast, a file that was previously saved (even weeks ago) and then re-opened and edited without saving changes gives you at least the last saved version to work from — even if you lose recent edits.

After Recovery: Change These Settings 🛠️

Once you've resolved the immediate situation, it's worth reviewing your AutoRecover configuration:

• Shorten the AutoRecover interval — 5 minutes is a reasonable balance between protection and system overhead
• Confirm "Keep the last autosaved version" is enabled — This is in File → Options → Save
• Consider saving to OneDrive — If your workflow allows it, cloud-connected files get continuous AutoSave, which is meaningfully more robust than local snapshots

How much any of these recovery paths will work for you depends heavily on your specific Excel version, operating system, how the file was being stored, and the exact circumstances of how it was lost — which is exactly why the same steps can produce different results for different people in seemingly similar situations.