Excel File Recovery: Complete Guide to Restoring Lost, Corrupted, and Deleted Workbooks
Master excel file recovery with proven methods to restore unsaved, deleted, and corrupted workbooks using AutoRecover, version history, and repair tools.

Excel file recovery is one of those skills you hope you never need, but when disaster strikes, knowing the right techniques can save hours of work and protect critical business data. Whether you accidentally closed a workbook without saving, suffered a system crash mid-edit, or opened a file only to find it corrupted, Excel offers multiple recovery pathways that most users never explore. This guide walks through every recovery option Microsoft has built into Excel, plus third-party safety nets that catch what AutoRecover misses. Practice with the free Excel practice test on PracticeTestGeeks (25 questions with answer explanations).
The most common recovery scenario involves unsaved work after an unexpected shutdown. Excel's AutoRecover feature, enabled by default, silently saves snapshots of your active workbook every ten minutes to a hidden recovery folder. When you reopen Excel after a crash, the Document Recovery pane appears on the left side, listing files that were open during the failure. Selecting any entry lets you preview and save the recovered version before discarding the older one.
Corrupted workbooks present a thornier challenge. A file might open with garbled formulas, missing sheets, or refuse to open at all, throwing errors like "Excel cannot open the file because the file format or extension is not valid." These situations require different tactics: the built-in Open and Repair function, opening the file through a different application like Excel Online, or extracting the underlying XML structure manually from the .xlsx archive.
Deleted files add another layer of complexity. If you emptied the Recycle Bin or deleted a workbook from a network share that doesn't keep version history, you may need file recovery software that scans the disk sector by sector for orphaned data. Tools like Recuva, Disk Drill, and EaseUS Data Recovery can find files that Windows considers gone, though success depends heavily on how much new data has been written to the drive since deletion.
Modern Excel users have additional safety nets that didn't exist a decade ago. OneDrive and SharePoint store version history automatically, letting you roll back to any saved state from the past thirty days or longer. Microsoft 365 subscribers can use AutoSave, which writes every change to cloud storage in real time, eliminating most data loss scenarios entirely. Even local files benefit from File History on Windows and Time Machine on macOS, both of which create periodic snapshots you can browse.
This guide is structured to take you from immediate panic-mode recovery through long-term prevention strategies. We'll cover how AutoRecover actually works, where Excel hides temporary files, how to repair damaged workbooks, when to call in professional data recovery services, and which habits eliminate ninety percent of future emergencies. Whether you're a finance analyst, a student, or an IT administrator managing dozens of users, these techniques belong in your permanent toolkit.
Before diving into specific methods, take a deep breath and stop using the affected drive if possible. Every new file you save reduces the chance of recovering deleted data, and aggressive troubleshooting on a corrupted file can sometimes make things worse. The right approach is methodical: identify what type of loss you're dealing with, try the least invasive recovery method first, and escalate only when simpler options fail.
Free Excel Study Tools
Interactive Excel resources on PracticeTestGeeks, free to start:
- EXCEL Practice Test: Video 1 Answers (25 Questions) โ 25 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
Microsoft Excel: upcoming dates and official changes
- Jun 30, 2026: Certiport retired the Microsoft Office Specialist 2016 certifications, including MOS Excel 2016, on June 30, 2026. The Microsoft 365 Apps and Office 2019 Excel exams are still available. (certiport.pearsonvue.com)
- Updated Oct 16, 2026: Delivery is now Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) (previously Proctored live-in-the-application exam via Certiport Authorized Testing Centers).
- Updated Oct 16, 2026: Eligibility is now No formal prerequisites; about 150 hours of instruction and hands-on experience recommended (previously No formal prerequisites; ~150 hours of instruction and hands-on experience recommended (Associate)).
- Updated Oct 16, 2026: Time limit is now 50 minutes (60 minutes seat time) (previously 50 minutes (60 minutes seat time)).
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.
- The MOS Excel (Microsoft 365 Apps) exam has 33 to 37 questions. (certiport.pearsonvue.com)
- The MOS Excel Expert (Microsoft 365 Apps) exam has 23 to 27 questions. (certiport.pearsonvue.com)
- Microsoft Office Specialist Excel exams last 50 minutes, with 60 minutes of total seat time. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- The passing score for Microsoft Office Specialist Excel exams is always 700 on Certiport's 1 to 1000 scaled score. (certiport.pearsonvue.com)
- After failing a Microsoft Office Specialist Excel exam, candidates must wait 24 hours before the first retake and 48 hours before each later retake, and there is no annual limit on attempts. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft Office Specialist Excel certifications earned on or after September 23, 2025 are valid for five years; those earned earlier do not expire. (certiport.pearsonvue.com)
- The Microsoft Office Specialist Excel exam is proctored and delivered live in the Excel application through Certiport Authorized Testing Centers, either in person or remote-proctored. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Microsoft recommends that candidates for the MOS Excel Associate (Microsoft 365 Apps) certification have about 150 hours of instruction and hands-on experience with Excel. (Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business)
- Candidates get their MOS Excel score report as soon as they finish the exam, and it can also be viewed in their Certiport profile. (certiport.pearsonvue.com)
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.
Microsoft Excel Exam at a Glance
| Item | Detail | Official source |
|---|---|---|
| Number of questions (Excel Associate (MO-210)) | 33-37 questions | certiport.pearsonvue.com |
| Number of questions (Excel Expert (MO-211)) | 23-27 questions | certiport.pearsonvue.com |
| Time limit | 50 minutes (60 minutes seat time) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Passing score | 700 on a 1โ1000 scale | certiport.pearsonvue.com |
| Retake policy | Wait 24h after 1st fail, 48h before each later retake; no annual limit | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Validity | Valid 5 years (earned on/after Sept 23, 2025) | certiport.pearsonvue.com |
| Delivery | Proctored live-in-the-application exam via Certiport Authorized Testing Centers (in-center or remote-proctored) | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Eligibility | No formal prerequisites; about 150 hours of instruction and hands-on experience recommended | Microsoft (Microsoft Office Specialist program), delivered by Certiport, a Pearson VUE business |
| Score release | Score report at end of exam; also in Certiport profile | certiport.pearsonvue.com |
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.
Excel File Recovery by the Numbers

How AutoRecover Saves Your Work
Enable AutoRecover Settings
Background Snapshot Creation
Crash or Force-Close Event
Document Recovery Pane Appears
Save or Discard the Recovery
Recovering unsaved workbooks ranks as the most frequent excel file recovery scenario, and Microsoft has built three distinct pathways to handle it. The first and most automatic is the Document Recovery pane that appears when you relaunch Excel after a crash. The second is the Recover Unsaved Workbooks button under File > Open > Recent. The third involves navigating directly to the UnsavedFiles folder on your local disk, which holds workbooks you created but never explicitly saved.
The Recover Unsaved Workbooks button is the unsung hero of Excel's recovery toolkit. Click File, then Open, then scroll to the bottom of the Recent files list. A button labeled "Recover Unsaved Workbooks" opens Windows Explorer pointed at the UnsavedFiles folder, typically located at C:\Users\YourName\AppData\Local\Microsoft\Office\UnsavedFiles. Files here use cryptic names but represent every new workbook you started without saving and then closed.
For workbooks you did save previously but lost recent changes on, the Manage Workbook option becomes essential. With your file open, click File then Info, and look for the Manage Workbook section. Excel lists any AutoRecover versions still available, letting you restore to a point earlier in your session. This works even if you saved over your changes, as long as AutoRecover captured the prior state before your save action.
Mac users follow a similar workflow but with different file paths. Excel on macOS stores AutoRecover files under ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Office/Office 2016 AutoRecovery (the path varies by version). Finder hides the Library folder by default, so you need to hold Option while clicking the Go menu to reveal it. The recovery files use .xlsb format and can be opened directly in Excel.
One critical detail many users miss: AutoRecover only protects workbooks that have been modified since the last manual save. If you open a file, make zero changes, and Excel crashes, no AutoRecover file gets created because there's nothing new to recover. This is by design, but it confuses users who assume every file gets a snapshot. The implication is that pure read-only sessions don't benefit from this safety net.
Network drives and shared folders add complications. AutoRecover writes to your local AppData folder regardless of where the source file lives, which means recovering a file from a network outage scenario works the same as recovering a local file. However, if multiple users co-author through legacy file-share mechanisms (not OneDrive co-authoring), AutoRecover only protects the version your specific instance of Excel was editing at the moment of failure.
The recovery folder fills up over time if you never clean it. Excel periodically purges files older than four days, but heavy users can accumulate gigabytes of orphan snapshots. Once a month, browse to the UnsavedFiles location and delete anything you no longer need. Don't delete files marked with recent timestamps unless you've confirmed the work is safely saved elsewhere, because these might be the only copy of recent changes you'd otherwise lose.

Microsoft Excel Practice Test Questions
Prepare for the Microsoft Excel exam with our free practice test modules. Each quiz covers key topics to help you pass on your first try.
Microsoft Excel Excel Basic and Advance
Microsoft Excel Exam Questions covering Excel Basic and Advance. Master Microsoft Excel Test concepts for certification prep.
Microsoft Excel Excel Formulas
Free Microsoft Excel Practice Test featuring Excel Formulas. Improve your Microsoft Excel Exam score with mock test prep.
Microsoft Excel Excel Functions
Microsoft Excel Mock Exam on Excel Functions. Microsoft Excel Study Guide questions to pass on your first try.
Microsoft Excel Excel MCQ
Microsoft Excel Test Prep for Excel MCQ. Practice Microsoft Excel Quiz questions and boost your score.
Microsoft Excel Excel
Microsoft Excel Questions and Answers on Excel. Free Microsoft Excel practice for exam readiness.
Microsoft Excel Excel Trivia
Microsoft Excel Mock Test covering Excel Trivia. Online Microsoft Excel Test practice with instant feedback.
Repairing Corrupted Workbooks Like a VLOOKUP Excel Power User
Excel's built-in Open and Repair function handles most corruption scenarios automatically. Launch Excel without opening the damaged file, then click File > Open > Browse and navigate to the affected workbook. Instead of double-clicking, select the file once, then click the dropdown arrow next to the Open button. Choose "Open and Repair" from the menu, and Excel will attempt to fix structural problems silently.
If standard repair fails, Excel offers a second option to extract values and formulas only, discarding formatting, charts, and macros. This sacrifices visual polish but often saves the raw data when nothing else works. Always make a backup copy of the corrupted file before attempting repair, because aggressive recovery operations can sometimes overwrite the original with a worse version that loses additional content.
AutoSave vs Manual Save: Which Approach Wins?
- +AutoSave eliminates virtually all data loss from crashes and power outages
- +Real-time cloud sync enables seamless collaboration with multiple editors
- +Version history captures every change automatically without user action
- +Mobile and tablet access stays synchronized with desktop edits instantly
- +Conflict resolution handles simultaneous edits gracefully without lost work
- +Disaster recovery becomes trivial when files live in OneDrive or SharePoint
- +No need to remember Ctrl+S habits that fail under deadline pressure
- โAccidental changes save immediately, with no chance to abandon edits
- โRequires Microsoft 365 subscription and cloud storage to function fully
- โNetwork outages can interrupt saves and create temporary sync conflicts
- โLarge workbooks may experience noticeable lag during constant background saves
- โSensitive data must comply with cloud storage policies in regulated industries
- โSome legacy add-ins behave unpredictably when AutoSave is enabled
Pros and Cons at a Glance
| Pros | Cons |
|---|---|
| AutoSave eliminates virtually all data loss from crashes and power outages | Accidental changes save immediately, with no chance to abandon edits |
| Real-time cloud sync enables seamless collaboration with multiple editors | Network outages can interrupt saves and create temporary sync conflicts |
| Version history captures every change automatically without user action | Large workbooks may experience noticeable lag during constant background saves |
| Mobile and tablet access stays synchronized with desktop edits instantly | Sensitive data must comply with cloud storage policies in regulated industries |
| Conflict resolution handles simultaneous edits gracefully without lost work | Some legacy add-ins behave unpredictably when AutoSave is enabled |

Excel File Recovery Emergency Checklist
- โStop using the affected drive or folder immediately to prevent overwriting deleted data
- โCheck the Document Recovery pane for any auto-recovered versions Excel detected
- โNavigate to File > Open > Recover Unsaved Workbooks to find unsaved sessions
- โLook in File > Info > Manage Workbook for previous AutoRecover snapshots
- โSearch the OneDrive or SharePoint version history if the file lived in cloud storage
- โTry Open and Repair from the File > Open dialog before deeper recovery methods
- โCreate a backup copy of the corrupted file before attempting any repair operations
- โUse external reference formulas to extract cell values when Open and Repair fails
- โRename .xlsx to .zip and extract XML files for last-resort manual data recovery
- โRun reputable file recovery software like Recuva if the file was deleted from disk
Always try Document Recovery first
When Excel crashes and reopens, the Document Recovery pane appears for roughly thirty minutes before Excel quietly removes the unsaved snapshots. Don't dismiss the pane until you've explicitly saved the recovered version to a new file name. Once dismissed, those recovery files are often unrecoverable, even though the underlying data may still exist briefly in your AppData folder.
Cloud-based recovery has fundamentally changed the calculus of excel file recovery for anyone using OneDrive, SharePoint, or Microsoft 365. Version history runs silently in the background, storing snapshots of every saved change for at least thirty days on personal accounts and often much longer on enterprise tenants. To access it, open the file in Excel, click File, then Info, and select Version History. A panel slides in showing every version with timestamps and the user who made the change.
Clicking any historical version opens it in a read-only window. You can review the contents, copy data to clipboard, or click Restore to make that version the current one. The original remains in history as a previous version, so you can always undo the restoration if needed. This non-destructive approach to recovery means experimenting with version history carries essentially zero risk, encouraging users to explore freely.
SharePoint takes this further with customizable retention policies. Administrators can configure retention from thirty days to permanent storage, with up to five hundred versions per file by default. Some compliance-heavy industries push this to thousands of versions for audit trails. The storage cost is real, since each version consumes disk space, but Microsoft uses block-level deduplication so unchanged portions of the file don't duplicate.
OneDrive's recycle bin offers another safety net distinct from version history. Deleted files sit in the recycle bin for thirty days for personal accounts and ninety-three days for business accounts. After expiration, files move to a second-stage recycle bin for an additional thirty days, accessible only by administrators. This two-tier system means an accidentally deleted workbook can be recovered up to roughly four months after deletion in business environments.
For files stored on Microsoft Teams channels, recovery follows the SharePoint model since Teams files live in SharePoint document libraries behind the scenes. The Files tab in any channel opens the underlying SharePoint folder, where version history, recycle bin, and check-in/check-out features all apply. Understanding this architecture helps Teams users find recovery options that aren't obvious from the Teams interface itself.
Conflict resolution during co-authoring deserves special attention. When two users edit the same workbook simultaneously and Excel detects conflicting changes, it creates a conflict copy and notifies users. Both versions remain accessible through version history, letting you compare changes and merge selectively. AutoSave's real-time sync prevents most conflicts, but legacy desktop-only edits or offline work can still create them when reconnection happens.
Backup strategies should layer cloud recovery on top of local backups, not replace them. OneDrive sync provides redundancy and history, but ransomware that encrypts your local files often syncs the encryption to OneDrive too. Microsoft's ransomware detection catches most cases and offers point-in-time recovery, but a third-party backup tool that captures Excel files separately gives you another defense layer for critical work.
When working on a template or making exploratory changes you might want to abandon, toggle AutoSave OFF in the top-left corner of the Excel window before editing. AutoSave commits every keystroke immediately, leaving no opportunity to discard changes by closing without saving. For experimental work, use Save As to create a working copy first, or disable AutoSave to preserve the traditional Ctrl+S workflow temporarily.
Prevention beats recovery every time, and a few habits eliminate most excel file recovery emergencies before they happen. The single highest-impact change is enabling AutoRecover with a shorter interval. The default ten minutes is acceptable, but five minutes provides far better protection during intensive editing sessions when you're entering complex formulas or building pivot tables that take hours to construct. The performance cost is negligible on modern hardware.
Storing critical workbooks in OneDrive or SharePoint instead of local folders unlocks version history, AutoSave, and ransomware protection automatically. Even if you prefer working on local files, mapping a OneDrive folder as your default save location for important projects gets you cloud benefits without changing your workflow. Files appear in File Explorer like any other folder, but every change syncs to the cloud silently in the background.
Naming conventions help recovery scenarios more than people realize. Including dates in file names like "Budget-2026-Q1-v3.xlsx" makes it obvious which version is current and lets you spot suspicious duplicates that might indicate a previous recovery operation. Version numbers also discourage saving over the master file when experimenting, since you can save as v4 instead and preserve v3 as a known-good baseline.
Periodic exports to a different file format act as cheap insurance. Once a week, save important workbooks as both .xlsx and .csv (for tabular data) or .pdf (for reports). CSV files have zero corruption risk since they're plain text, and any data preserved in CSV can be rebuilt into Excel even if every .xlsx version on the system gets destroyed. This belt-and-suspenders approach takes thirty seconds and has saved countless analysts from disaster.
External backups complete the prevention picture. Windows File History, macOS Time Machine, and third-party tools like Backblaze or Macrium Reflect create point-in-time backups that survive scenarios cloud sync can't help with, such as accidentally deleting a folder and then emptying both the local recycle bin and the OneDrive recycle bin. A daily external backup combined with cloud version history covers virtually every failure mode imaginable.
For team environments, establish a backup policy and communicate it clearly. Confusion about who is responsible for backups leads to gaps where everyone assumes someone else has the situation covered. Document the location of master files, the retention period for versions, who has restore permissions, and how to request recovery of deleted items. New team members should learn this protocol during onboarding alongside other essential procedures.
Finally, test your recovery procedures before you need them. Once a quarter, pick a non-critical file, simulate a loss scenario (delete it, corrupt it, or close without saving experimental changes), and walk through your recovery process. This exercise reveals gaps in your knowledge or procedures while the stakes are low. Discovering that your backup software hasn't run for six months during an actual emergency is the worst possible time to learn.
Practical excel file recovery extends beyond Microsoft's built-in tools when you face truly catastrophic loss. Commercial recovery software like Stellar Repair for Excel, DiskInternals Excel Recovery, and Recovery Toolbox for Excel specialize in extracting data from severely damaged .xlsx and .xls files. These tools cost between fifty and three hundred dollars but routinely recover workbooks that Excel itself declares unreadable. Free trials let you preview recoverable content before paying, which is genuinely useful for evaluating whether the tool can help your specific case.
For deleted files on a physical disk, Recuva from CCleaner offers a capable free option that scans NTFS, FAT, and exFAT volumes for orphaned files. The deep scan mode finds files even after Recycle Bin emptying, though success drops sharply as new data overwrites the deleted sectors. EaseUS Data Recovery Wizard and Disk Drill provide more polished interfaces and broader file format support, with paid tiers unlocking unlimited recovery sizes for serious data salvage operations.
SSD recovery differs meaningfully from spinning disk recovery. The TRIM command, enabled by default on modern Windows installations, immediately erases deleted file sectors on SSDs for performance reasons. This makes traditional sector scanning nearly useless on SSDs because the data is genuinely gone within minutes of deletion. Cloud backups, version history, and AutoRecover become exponentially more important for SSD-based systems where local file recovery is largely a lost cause.
Professional data recovery services handle hardware-level failures that software can't address. If a drive makes clicking sounds, fails to spin up, or shows up in BIOS but not in Windows, software recovery will only make things worse. Services like DriveSavers, Ontrack, and Secure Data Recovery operate cleanroom facilities to physically repair or transplant drive components. Costs range from five hundred to several thousand dollars depending on damage severity, but for irreplaceable data, the price is often justified.
Excel macro-enabled workbooks (.xlsm) carry additional recovery considerations. The macro code lives in the file's VBA project structure, which corruption can damage independently of cell data. Sometimes a workbook opens with all data intact but throws errors when macros run. Opening the file with macros disabled (hold Shift while opening), then exporting modules through the VBA editor before re-saving, can salvage code from otherwise broken files. Always export critical VBA modules to .bas files as a routine backup practice.
Linked workbooks and external data connections complicate recovery in subtle ways. A workbook might appear corrupted because a linked source has moved or been deleted, leaving broken references that throw errors on open. Before assuming corruption, check whether the file references external workbooks, databases, or web queries that might be unreachable. Disabling links during open (Excel prompts you when broken links exist) often reveals that the file itself is fine.
Document your recovery successes for future reference. Each time you successfully recover a file, note the symptom, the technique that worked, and any tools used. Over time, this personal knowledge base becomes invaluable when similar problems recur. Share it with colleagues who handle Excel-critical work, and consider building it into your team's onboarding documentation. Institutional knowledge about recovery procedures pays dividends every time someone faces a crisis with a clear playbook instead of panicked Googling.
If you want more targeted practice, the excel new page covers the same material with additional questions and explanations.
If you want more targeted practice, the ms excel download free page covers the same material with additional questions and explanations.
If you want more targeted practice, the microsoft excel exam practice test page covers the same material with additional questions and explanations.
Sample Excel Practice Questions
Try these questions from our free Excel practice tests. The correct answer and an explanation follow each question.
What file extension does a macro-enabled Excel workbook use?
- A. .xlsm
- B. .xlsx
- C. .xlsb
- D. .xltm
Answer: A. .xlsm
The .xlsm extension indicates a macro-enabled workbook that can contain VBA macros, while .xlsx files cannot store macros.
How many worksheets does a new Excel workbook contain by default in Excel 2016 and later?
- A. 1
- B. 3
- C. 5
- D. 10
Answer: A. 1
Starting with Excel 2013, new workbooks default to 1 worksheet. Earlier versions defaulted to 3 worksheets.
How do you encrypt an Excel workbook?
- A. Cannot be encrypted
- B. File > Info > Protect Workbook > Encrypt with Password (AES-256)
- C. Only macro files
- D. Requires add-in
Answer: B. File > Info > Protect Workbook > Encrypt with Password (AES-256)
Encrypt with Password applies AES-256 encryption to the entire file.
When using the 'Arrange All' command to view multiple open workbooks, which option will display the windows in an overlapping fashion from top to bottom?
- A. Tiled
- B. Horizontal
- C. Vertical
- D. Cascade
Answer: D. Cascade
The 'Cascade' option in the Arrange Windows dialog box arranges the open workbook windows so that they overlap, with the title bar of each window remaining visible. Tiled, Horizontal, and Vertical options arrange the windows without overlapping.
Excel Questions and Answers
Written and edited by Nathan Beja, founder of Practice Test Geeks, with AI assistance. Exam facts are checked against the official sources linked below. Editorial policy
Sources & references
Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy
- learn.microsoft.com โ Retake policy, test delivery, time limit, eligibility ยท verified Oct 2026
- certiport.pearsonvue.com โ Exam format, score validity, passing score, score release, exam information ยท verified Oct 2026




