Docs tower · floor

How to recover unsaved Excel file data, and do it now

If you are reading this because a spreadsheet has just vanished, go straight to the box below that matches your situation and come back afterwards. How to recover unsaved excel file work has two answers, and Microsoft puts the difference in one line: “How you recover something depends on when you saved it.”

you had saved it at least once

Look for the version labelled “when I closed without saving”

  1. Open the file you were working on.
  2. Go to File › Info.
  3. “Under Manage Workbook … select the file labeled (when I closed without saving).”
  4. “In the bar at the top of the file, select Restore to overwrite any previously saved versions.”

you had never saved it at all

Recover Unsaved Workbooks

  1. File › Info › Manage Document › Recover Unsaved Workbooks.
  2. Select the file, then Open.
  3. “In the bar at the top of the file, select Save As to save the file.”

Do not skip that third step. Recovering the workbook puts it on screen; it does not put it anywhere permanent. Save it before you look at anything else.

Try the second route even if you think the first applies. The two lists are separate places, and a workbook you saved once under a name you no longer remember can sit in the unsaved list while you hunt through Manage Workbook for it. Looking in both takes twenty seconds.

“If the recovery file is saved only every 15 minutes, your recovered file won’t contain your last 14 minutes of work before the power failure or other problem occurred.”

Microsoft, read 22 August 2026, and it is the sentence that sets your expectations correctly before you open anything. AutoRecover does not save your work — it takes photographs of it at intervals, and what you get back is the last photograph. Microsoft’s own advice on the same page is to make the interval small: “enter a small number in the minutes box, like 5 or 10. That way, you’ll never lose more than 5 or 10 minutes of work.”

The two boxes that decide whether any of this works

File › Options › Save. Worth checking now rather than at the moment you need them.

Save AutoRecover information every x minutes
The interval above. If this is off, there are no photographs to recover from.
Keep the last autorecovered version if I close without saving
This is the one nobody knows about, and it is the one that covers the commonest accident. A crash is not what usually loses a spreadsheet — a person closing it and clicking Don’t Save is. Without this box ticked, that case is not covered at all.

Now the part worth reading once the panic is over. Five of the first seven results Google returns for this question are people asking for help on forums — a Microsoft community post titled “Excel spreadsheet disappeared and I cannot…”, a Reddit thread beginning “I accidentally closed a workbook without saving”, and three more like them. Microsoft’s own instructions are not on the first page at all. That is a fair measure of how badly this question is served, and of how many people never find the two routes above.

The arrangement that makes all of this unnecessary. Microsoft is direct about it: save the file to OneDrive or SharePoint and “use AutoSave to save your changes continuously”. A file in a synced location with AutoSave on is saved as you type, and it keeps a version history you can step back through. That is a different category of protection from AutoRecover, which is a safety net rather than a save.

And Microsoft says the obvious thing twice, so it is worth repeating. “Even if AutoRecover is turned on, you should save the file frequently … to avoid losing data because of an unexpected power failure or other problem.” Ctrl+S remains the only method on this page that loses nothing at all.

The two recovery routes, the AutoRecover settings, the arithmetic of the interval and the advice about AutoSave are quoted from Microsoft’s own Office documentation, read on 22 August 2026 and listed below. The advice to check both lists, and the observation about what Google returns for this question, are ours.

Where to start

Four ways in.

“I closed it and clicked Don’t Save.”
Both boxes above, starting with the first — the two routes
“It was never saved at all.”
Recover Unsaved Workbooks — the two routes
“How much will I get back?”
The interval decides — what autorecover actually is
“Make sure this never happens again.”
Two boxes and one setting — setting it up properly

The two routes

Which one you need depends on whether the workbook had ever been saved. They are different lists in different menus.

Hidden rows in ExcelThree clicks — and the four reasons they fail, including the one where the rows were never hidden.Open this floor → Hidden columns in ExcelColumn A needs a different method, and one explanation can be ruled out immediately.Open this floor → Comparing two workbooksMicrosoft’s tool is restricted to enterprise Windows — and one helper column does the job anywhere.Open this floor →

What AutoRecover actually is

Photographs at intervals, not a save. How much you get back is decided by a number you can change today.

BackupsThe arrangement that makes an irreversible loss survivable, set up once.Open this floor →
Comparing cloud storageWhat each service costs, and what happens to your files if you stop paying.Being built
Freeing up disk spaceThe nine methods Microsoft publishes in its own order.Open this floor →

Setting it up properly

Two checkboxes and a location. Five minutes now against an afternoon later.

Lock cells in ExcelEvery cell is already locked, so the real job is unlocking the ones people should edit.Open this floor → Drop-down lists in ExcelPut the source in a table so it updates itself, and the option that decides whether the list is enforced.Open this floor → Checkboxes in ExcelHere the box is the cell’s value, so the ticks can be counted.Open this floor →

When the file is damaged

A workbook that opens wrongly is a different problem from one that never got saved, and it has its own route.

PDF to ExcelWhat survives the conversion, and the numbers that arrive as text.Open this floor → Wrapping text in ExcelTwo ways to break a line in a cell, and the two documented reasons the wrapped text stays invisible.Open this floor →
Spreadsheets as softwareThe point at which a spreadsheet has quietly become an application.Being built

What this tower will not do

It will not sell you recovery software. Both routes are inside Excel, and Microsoft documents them on a page Google does not show you.

It will not promise you everything back. AutoRecover saves at an interval, and Microsoft states plainly what that costs you.

And it will not skip the Save As step. A recovered workbook is on screen, not saved, until you save it. What holds instead is simple: both recovery routes, the AutoRecover settings and the note about how much work an interval costs are quoted from Microsoft’s own Office documentation, with the date each page was read.

Where this page got its facts

  1. Microsoft Support — Recover an earlier version of an Office file, including the statement that how you recover depends on when you saved, the Manage Workbook route for saved files and the Manage Document › Recover Unsaved Workbooks route for files never saved — support.microsoft.com, read 22 August 2026.
  2. Microsoft Support — Help protect your files in case of a crash, including the two AutoRecover checkboxes, the note about how much work an interval costs and the advice to use AutoSave on OneDrive or SharePoint — support.microsoft.com, read 22 August 2026.
  3. Microsoft Support — Save, back up, and recover a file in Microsoft Office, including the Document Recovery pane and the reminder to save frequently even with AutoRecover on — support.microsoft.com, read 22 August 2026.

Written by Alberto Gulotta

Founder and editor of AI Tools Primer, writing from Palermo, Italy. Thirty-five years of taking computers apart, starting with a Commodore 64 — the long version is on the about page.

Something wrong on this page? Write to aitoolsprimer@gmail.com and it gets fixed.

Written on 22 August 2026.

Independence and limits

No affiliate links and no paid placements anywhere on this site. Nobody pays to appear here, and no company has seen this page before you did.

This is general information, not professional advice. Where a page touches money, health, safety or the law, it names its source and the date it was read — and your situation may still differ. See the privacy page and the cookie policy.