Recover Excel File: Complete Guide to AutoRecover, Unsaved Workbooks, and Corrupt File Repair

Recover Excel File: Every Method That Actually Works

Losing an Excel file feels like losing hours of careful work in a single click. Maybe the app crashed during a long save, maybe you hit Don't Save by accident, or maybe the workbook now refuses to open and shows a corrupt-file error. The good news: Excel keeps more copies of your data than most people realize, and recovery is possible in the majority of cases when you act quickly. This guide walks through every method that works, from the built-in AutoRecover pane to OneDrive version history. Practice with the free Excel practice test on PracticeTestGeeks (500+ questions with answer explanations).

Before you panic and start clicking around, stop. The single biggest mistake people make is opening Excel again, creating a fresh file, and saving over the temp directory. That overwrites the very files you need. Read through the steps below first, identify which scenario matches yours, then follow the matching path. Recovery success drops dramatically the more you fiddle with the system after a crash, so patience is the most important tool you have right now.

Microsoft Excel Exam at a Glance

Facts verified Oct 17, 2026 against Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business. Dates that have passed are removed automatically.

Free Excel Study Tools

Interactive Excel resources on PracticeTestGeeks, free to start:

• Free Excel Questions and Answers — 16 questions with instant scoring and answer explanations
• Excel flashcards — review key terms and concepts card by card
• Excel study guide — topic-by-topic overview of what the exam covers
• Excel cheat sheet — one-page printable summary for last-minute review

Method 1: Use AutoRecover After a Crash

Excel saves an AutoRecover snapshot every ten minutes by default. If you opened Excel after a crash and there is nothing in the Document Recovery pane on the left, the file might still be in the AutoRecover folder. Go to File then Options then Save and copy the path next to AutoRecover file location. Paste that path into Windows Explorer. You will see .xlsb or .xlsx files with names like the original. Drag the most recent one to your desktop, rename it with a clean .xlsx extension, and double-click to open.

Nine times out of ten you will see your work from the last ten-minute checkpoint. Save the recovered file under a new name immediately so a second crash cannot wipe it out. Do not edit before you save. If the pane shows several candidates, open each one in turn and pick the one with the most complete data. Excel sometimes saves a partial snapshot during a crash, and the second-newest file can occasionally hold more rows than the freshest one.

Method 2: Recover Unsaved Workbooks

If you saved the file at least once and then closed without saving the latest changes, head to File then Info then Manage Workbook then Recover Unsaved Workbooks. Excel opens a window pointing at the UnsavedFiles directory. Sort by date modified, pick the latest, and open it. Save it immediately with a new name to lock in the recovery. Do not work on the recovered file before saving — if Excel hiccups again, you lose the snapshot and have to start the process over.

Brand-new workbooks that you never named also land in this folder. They appear with cryptic names like Book1_random.xlsb but they hold all your data. Sort by date and trust the timestamp. After you save under a real name, Excel cleans the UnsavedFiles folder during the next clean shutdown. Until you save, your work lives in a deletion countdown — every minute of delay risks losing the file when Windows runs scheduled maintenance.

Method 3: Restore From OneDrive Version History

OneDrive and SharePoint users have an even better option: version history. Right-click the file in OneDrive or open it in Excel for the web, choose Version History, and you will see every saved snapshot going back days or weeks. Restore the one before the bad save. This works even if you accidentally deleted half the sheet, saved, and closed — as long as the file lives in a synced OneDrive or SharePoint folder. Local-only files do not get this safety net, which is reason enough to move every important workbook to the cloud.

Microsoft 365 keeps up to 500 versions per workbook for free. SharePoint admins can extend retention even further from site library settings. Restoring a version does not delete the current copy — the rolled-back file becomes the new top version and the previous current file slides one slot down the list. You can always undo an undo. For finance teams using budget templates in Excel, this is the closest thing to a real undo button after a coworker pastes over your sheet.

Method 4: Open and Repair a Corrupted File

For a corrupted file that will not open at all, Excel has a built-in repair tool most users never find. Open Excel without opening the file. Click File then Open then Browse, navigate to the broken file, click it once, then click the small arrow next to the Open button and choose Open and Repair.

Try Repair first. If that fails, click the same option again and choose Extract Data. Extract pulls out values and formulas as text — you lose formatting and charts, but you keep your numbers, which is usually what matters most when the deadline is in two hours.

Open and Repair handles workbooks damaged by USB stick ejection mid-save, by Excel crashes during very large pivot table refreshes, and by network drive disconnects. It cannot fix files corrupted by ransomware encryption or by bit rot on a failing disk. If repair fails twice and extract fails once, move on to the temp-file trick below or a third-party tool. Trying repair five more times will not change the result and may make the corruption slightly worse each pass.

Method 5: Hunt for Temp Files

Power users should know about the temp-file trick. While Excel runs, it creates working copies in the user temp directory with names like tilde-DF followed by random hex strings. After a crash, those files sometimes survive even when AutoRecover does not catch them. Press Windows+R, type %temp%, and look for files dated near the crash. Rename anything suspicious to .xlsx and try opening it. This is messy and not guaranteed, but it has rescued plenty of workbooks that everything else gave up on.

Sort by date modified and ignore everything older than the crash. Excel temp files larger than fifty kilobytes almost always contain real data. The lock files Excel creates alongside the working copy are zero bytes and useless for recovery, but their presence near a real .tmp file is a strong signal you are looking at the right session. Move the candidate to your desktop before renaming, otherwise Windows can sweep the temp folder during the next reboot and delete your only copy.

AutoSave and the Microsoft 365 Advantage

Microsoft 365 subscribers get the cleanest recovery story because every save goes to the cloud automatically when AutoSave is on. Check the AutoSave toggle in the top-left of any open Excel window. If it is off, turn it on now and never look back. AutoSave plus OneDrive version history is the closest thing to a real undo button for spreadsheet disasters. If you have ever sweated through a deadline because Excel crashed mid-save, this combination is worth the subscription cost on its own.

Excel 2019 and Excel 2021 standalone licenses do not have AutoSave-to-cloud out of the box, but they still run AutoRecover. The same File then Options then Save screen lets you crank the AutoRecover interval down from ten minutes to one minute. Do this on any machine where you work on important files. The performance cost is invisible on modern hardware, and the safety margin is enormous. One minute means you lose at most a minute of work — usually a few cells worth, easily retyped from memory.

Third-Party Repair Tools as a Last Resort

When the file is truly broken and Excel's own repair fails, third-party tools take over. Stellar Repair for Excel, Recovery Toolbox for Excel, and DataNumen Excel Repair all claim to fix corrupt .xlsx files. Download trial versions first — they show a preview of what they can recover before you pay. The previews are honest in practice, and you should never pay for a tool that cannot show the data before charging the card. Expect to spend between fifty and one hundred fifty dollars for a single-file recovery license.

Free options exist too: open the .xlsx file as a ZIP archive (rename to .zip), navigate to xl/worksheets/sheet1.xml, and copy the XML into a fresh workbook. Tedious but free, and it works when the binary structure is broken but the cell data inside is intact. This trick rescues simpler workbooks reliably and is worth ten minutes before you spend money on commercial repair software. Always work on a copy of the file, never the original — extraction sometimes mangles what little structure is left.

Mac and Cross-Platform Notes

Mac users follow a slightly different path. AutoRecover files live under ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office. The Finder hides the Library folder by default — press Cmd+Shift+G and paste the path. Mac Excel also has Open and Repair, but it is tucked behind File then Open with a dropdown next to the Open button. Workflow is otherwise identical: pick the file, choose repair, then extract if repair fails. The cloud-sync features behave the same on Mac as they do on Windows.

Cross-platform teams often hit a subtle problem: macOS file paths and Windows file paths break links inside the workbook. If you recovered the file on a Mac but the original was Windows, external references to other workbooks may show #REF! errors. Re-establish the links manually through Data then Edit Links, or use Excel for the web which papers over the path differences automatically. This trips up finance teams that share a single model across operating systems.

Prevention Habits That Replace Recovery

Network drives, USB sticks, and external hard drives cause more recovery problems than crashes do. If you saved your workbook to a flaky USB drive and now it will not open, copy the raw file to your local desktop before doing anything else. Then run Open and Repair on the local copy. Working directly off bad media risks making the corruption worse with every read attempt. A good rule: save to local disk, then sync to cloud or USB, never the other way around — Excel was never designed to live on removable storage.

For people who maintain massive financial models, set up a manual backup ritual that runs alongside AutoSave. Use a macro that saves a copy with a timestamp every time you close the file. Run this from the Workbook_BeforeClose event. You end up with a versioned history on local disk that does not depend on cloud sync. Engineers and analysts who learn this trick once never lose another model. Prevention beats recovery every time — treat the first ten minutes of every workbook like a setup checklist.

Confirm AutoSave is green, confirm AutoRecover interval is one minute, confirm the file lives in OneDrive or SharePoint. Once those three boxes are checked, you can work for hours without worrying about a power cut or a Windows update reboot. The recovery techniques above exist because most people skip the prevention step. Build the safety net once and you will never need this guide again — but bookmark it anyway, because the day will come when a coworker calls in a panic asking how to get their quarterly forecast back.

Pros and Cons at a Glance

Test Your Excel Skills

If you want to test your Excel skills more broadly while you wait for that recovery to finish, our Microsoft Excel practice tests cover formulas, formatting, charts, and data tools. They are a useful gut-check on whether your day-to-day Excel knowledge is current. Practice sessions also reinforce the keyboard shortcuts that protect you from accidental data loss — the same shortcuts that make AutoSave and version history feel natural rather than forced. A few minutes of practice today saves hours of panic the next time something goes wrong.

Recovery is reactive. The next time you open a critical workbook, take three minutes to verify your AutoRecover settings, turn on AutoSave, and confirm the file is in a versioned location. Future-you will thank present-you when the next crash happens — and there will be a next crash. Excel has improved enormously over the last decade, but it still runs on top of operating systems, networks, and human fingers, none of which are perfect. Defense in depth is the only strategy that actually works.

Share the recovery flow with anyone who edits Excel files as part of their job — finance teams, project managers, scientists, students. Excel recovery is a universal skill in 2026, but almost nobody learns it before they need it. Forwarding this guide once can spare a coworker the worst hour of their week. Then revisit the page yourself every six months to make sure Microsoft has not moved any of the menu paths around, because the UI does shift quietly between updates and the old screenshots stop matching reality.

What to Do When Nothing Worked

When AutoRecover, the temp folder, and version history all come up empty, third-party tools become an option. Stellar Repair for Excel, EaseUS Data Recovery, and Recuva all scan the disk for deleted file signatures. They cost between fifty and one hundred thirty dollars and work best if you have not written much new data since the loss. Install the tool on a different drive than the one that held the workbook — writing the installer to the same drive can overwrite the very sectors you need most.

If the file is critical and the third-party scan still fails, send the drive to a clean-room data recovery service. Expect a quote between three hundred and fifteen hundred dollars depending on the drive size and the urgency. Reputable shops only charge if they actually recover your data. Before you ship anything, ask whether their lab is ISO 5 certified. SSDs are particularly hard to recover because TRIM zeros out the deleted sectors within seconds — pull the drive and power it off immediately if you have any hope of professional recovery.

Sample Excel Practice Questions

Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.

1. What file formats can Excel save workbooks in?

   • A. Only .xlsx
   • B. Multiple: .xlsx, .xlsm, .xlsb, .xls, .csv, .pdf, .html, and more
   • C. Only .xlsx and .csv
   • D. Only Microsoft formats

   Answer: B. Multiple: .xlsx, .xlsm, .xlsb, .xls, .csv, .pdf, .html, and more

   Excel supports many formats including .xlsx, .xlsm, .xlsb, .csv, .pdf, .html, .xml, .ods.

2. Which of the following is NOT a valid cell reference style in Excel?

   • A. A1
   • B. R1C1
   • C. AA100
   • D. 1A

   Answer: D. 1A

   Cell references in the A1 style must begin with the column letter(s) followed by the row number.

3. Which Excel tool allows you to see the impact of changing input values on formula results?

   • A. What-If Analysis (Data Tables)
   • B. Solver
   • C. Formula Auditing
   • D. Scenario Manager

   Answer: A. What-If Analysis (Data Tables)

   What-If Analysis with Data Tables lets you substitute different input values into formulas to see how results change, making it ideal for sensitivity analysis.

4. What does the AutoFill handle look like in Excel?

   • A. A small square at the bottom-right corner of a selected cell
   • B. A green arrow pointing down
   • C. A blue circle in the center of the cell
   • D. A double-headed arrow on the cell border

   Answer: A. A small square at the bottom-right corner of a selected cell

   The AutoFill handle is the small green square that appears at the bottom-right corner of a selected cell or range.

Take the full Excel practice test