Excel File Disappeared? Here's How to Recover It (Step-by-Step)

If your Excel file disappeared, the fastest path to recovery depends on whether you saved it: unsaved files need AutoRecover (File > Info > Manage Workbook), while saved-but-missing files usually turn up through Windows Search or the Recycle Bin. For cloud users, OneDrive and SharePoint both maintain version history that you can restore in minutes. Read through the methods below in order; the first one that matches your situation is where you should start.

What You'll Achieve, and What You Need Before You Start

This guide gives you a clear, step-by-step path to finding or recovering a lost Excel file, whether it was never saved, saved but impossible to locate, accidentally deleted, or lost to a sync error. By the time you finish, you'll have exhausted every realistic recovery option and put prevention measures in place so this doesn't happen again.

The stakes here are real. According to ITPro, 82% of finance professionals report an emotional attachment to Microsoft Excel, which makes a disappeared Excel file all the more stressful. As highlighted in a review published by PMC (National Institutes of Health), Microsoft Excel is widely relied upon as the primary tool for statistical analysis and data management, making a missing Excel file a serious productivity concern.

Before you start, gather the following:

• Operating system: Windows 10/11 or macOS (steps differ slightly)

• Excel version: 2016, 2019, or Microsoft 365

• File details: The approximate file name or the last folder you saved it to

• Admin rights: Required for some recovery methods on managed work computers

No single method works for every situation, so the sections below are ordered from quickest to most involved. Start at the top and work down.

Why Did Your Excel File Disappear?

Before jumping into fixes, it helps to know which problem you're actually solving. PC Laptops can help prevent data loss.

• Saved to the wrong location — The file exists, just not where you expect. OneDrive vs. local drive confusion is the most common culprit, especially if your Documents folder redirects to the cloud automatically.

• Sent to the Recycle Bin — An accidental keystroke or drag-and-drop can delete a file without any obvious warning.

• Never fully saved — Excel crashed, the laptop died, or you closed the window and clicked "Don't Save" by reflex.

• AutoRecover was disabled — As noted by an Excel Training Specialist at Acuity Training, "By default, Excel has an auto-recover feature that saves a copy of the Excel file you are working on at set intervals." If that feature was turned off, there may be no temp file to retrieve.

• File name changed unintentionally — Rename accidents or version-numbering habits make files invisible to a quick search.

• OneDrive or SharePoint sync issue — Files can appear to vanish locally when cloud sync moves them to online-only storage.

• Windows or macOS update — System updates occasionally reset default save locations or shuffle folder structures.

Quick decision guide:

Did you ever save the file at all?

• No → Start with Method 1 (AutoRecover)

• Yes, but I can't find it → Start with Method 2 (Windows/Mac Search)

• Yes, and I think I deleted it → Start with Method 3 (Recycle Bin / Previous Versions)

• Yes, it was on OneDrive or SharePoint → Start with Method 4 (Cloud Version History)

Identifying the right cause saves you from wasting time on methods that can't apply to your situation.

Method 1: Recover Unsaved Excel Data Using AutoRecover

Work through these steps immediately; do not open another file or restart Excel before you do.

Step 1: Open Excel. If Excel is already open with a blank document, leave it. Don't open anything else yet.

Step 2: Click File in the top-left ribbon, then select Info.

Step 3: Click Manage Workbook (you'll see a dropdown arrow next to it), then select Recover Unsaved Workbooks.

[Screenshot placeholder: File > Info > Manage Workbook dropdown highlighted]

Step 4: A file browser window opens, showing a list of unsaved workbook files. Identify your file by matching the date and time to when you were last working on it.

Step 5: Open the file. As soon as it loads, go to File > Save As and save it to a specific folder with a clear name. Do not skip this — AutoRecover files are temporary and can be purged.

Step 6: If the unsaved workbooks list is empty, navigate to the AutoRecover folder manually:

• Windows path: C:\Users\YourUsername\AppData\Roaming\Microsoft\Excel\

• Mac path: ~/Library/Containers/com.microsoft.Excel/Data/Library/Preferences/AutoRecovery/

[Screenshot placeholder: File Explorer showing AppData path with .asd files visible]

Step 7: Look for files with the .asd extension. Copy any relevant file to your Desktop and rename it with a .xlsx extension, then open it in Excel.

⚠️ Common Mistake: Do not close Excel or open a second workbook before completing recovery. Doing so can trigger Excel to overwrite or delete the temp file you need.

AutoRecover only works if the feature was enabled before the file went missing, which is why the prevention section at the end of this guide matters.

How to Verify Your AutoRecover Settings

Go to File > Options > Save. Confirm that "Save AutoRecover information every X minutes" is checked, and set the interval to 5 minutes if it isn't already. Also, confirm the AutoRecover file location path matches the folder you searched above. Click OK to save any changes.

ANOTHER USEFUL READ: How to recover lost files during holiday travel.

Method 2: Find a Missing Excel File Using Windows Search and File Explorer

These steps will surface it.

Step 1: Press Windows + S to open the search bar. Type the file name, or if you don't remember the exact name, type .xlsx to pull up all Excel files on the computer.

Step 2: In the search results panel, click Documents or More to filter by file type. Use the Date Modified filter to narrow results to the period when you last worked on the file.

[Screenshot placeholder: Windows Search bar with .xlsx typed and Date Modified filter visible]

Step 3: If the name is completely unknown, open File Explorer, click This PC in the left panel, and type *.xlsx in the search box at the top right. This returns every Excel file across all drives.

Step 4: Sort results by Date Modified (newest first) to bring the most recently touched files to the top.

Step 5: Manually check these default save locations if search results are thin:

• Desktop

• Documents

• Downloads

• C:\Users\YourUsername\OneDrive\

Step 6: Right-click any likely file and select Open File Location to confirm exactly where it lives on your system.

⚠️ Common Mistake: OneDrive sometimes marks files as "cloud only," removing the local copy. If you see a cloud icon next to the file in File Explorer, click it once to download it locally before opening.

Mac: Use Spotlight to Find a Missing Excel File

Press Command + Space to open Spotlight. Type the file name or kind:spreadsheet to filter for all spreadsheet files. Sort results by date in Finder by pressing Command + F, then setting the search scope to "This Mac" and filtering by date.

Method 3: Restore an Excel File from the Recycle Bin or Previous Versions

PC Laptops has debunked common file recovery methods to save you from frustration.

Scenario A — Windows Recycle Bin:

• Double-click the Recycle Bin on your desktop.

• Search or scroll for the file name.

• Right-click the file and select Restore, and it returns to its original folder.

• Open the file in Excel and confirm the content is intact.

[Screenshot placeholder: Recycle Bin with right-click Restore option highlighted]

Scenario B — Windows Previous Versions:

• Navigate to the folder where the file was originally saved.

• Right-click the folder and select Properties.

• Click the Previous Versions tab.

• Select a snapshot from before the file disappeared.

• Click Open to preview the folder contents, find the file, and copy it out, or click Restore to roll the entire folder back.

[Screenshot placeholder: Folder Properties > Previous Versions tab]

⚠️ Common Mistake: Previous Versions only populates if Windows File History or System Restore was enabled before the file went missing. If the tab is empty, move to Method 4 or Method 5.

Scenario C — Mac Time Machine:

• Open the folder where the file was stored.

• Click the Time Machine icon in the menu bar and select Enter Time Machine.

• Use the timeline on the right to navigate back to a date when the file existed.

• Select the file and click Restore.

If the file was overwritten rather than deleted, Previous Versions or Time Machine may still show an earlier version. Overwritten files cannot be recovered from the Recycle Bin. For that, move to Method 4 (cloud version history) or Method 5 (recovery software).

Method 4: Recover a Lost Excel File from OneDrive or SharePoint Version History

OneDrive Recovery — Deleted File:

• Go to onedrive.live.com and sign in with your Microsoft account.

• Navigate to the folder where the file was stored.

• If the file isn't visible, click Recycle Bin in the left sidebar. OneDrive has its own separate Recycle Bin, independent of Windows.

• Locate the file, right-click it, and select Restore.

[Screenshot placeholder: OneDrive left sidebar with Recycle Bin highlighted]

OneDrive Recovery — Overwritten or Corrupted File:

• While in OneDrive, locate the file in its folder.

• Right-click the file and select Version History.

• A panel opens showing every saved version with timestamps.

• Click a previous version to preview its contents.

• Select Restore to replace the current version with the earlier one.

💡 OneDrive retains version history for up to 30 days on personal plans. Microsoft 365 Business and Enterprise plans extend this significantly. Check with your IT admin for your organization's retention window.

Recovering Files from SharePoint Version History

SharePoint stores files in document libraries that track every change automatically.

• Open the SharePoint document library where the file was stored.

• Hover over the file name and click the three-dot menu (...).

• Select Version History from the dropdown.

• Review the list of versions by date and author.

• Click the timestamp of the version you want, then select Restore, or open it first to verify the content.

⚠️ Common Mistake: If you deleted your Microsoft account, or the file lived in a shared folder you no longer have access to, contact your IT administrator or Microsoft Support directly. Version history cannot be accessed without permissions.

This is the recovery path that many guides skip, and for business users storing files in SharePoint, it's often the fastest and most complete solution available.

Method 5: Use Data Recovery Software for Permanently Deleted Excel Files

When a file is deleted, and the Recycle Bin is emptied, the data isn't immediately gone. The space is simply marked as available for reuse. Recovery tools scan for those remaining traces before they're overwritten.

Step 1: Stop using the affected drive immediately. Every file you download, save, or install increases the chance of overwriting the data you're trying to recover.

Step 2: Download a recovery tool to a different drive; a USB drive or secondary hard disk works well. Using the same drive for the software and the recovery target risks destroying recoverable files.

Step 3: Run a deep scan of the drive or partition where the Excel file was stored. This may take several minutes.

Step 4: Filter results by file extension: .xlsx, .xls, or .csv.

Step 5: Preview recoverable files before restoring them to confirm they're the right ones.

Step 6: Save all recovered files to a different drive — not the one you just scanned.

⚠️ Common Mistake: Installing recovery software on the same drive you're recovering from is one of the most common ways people accidentally destroy the file they're trying to save. Always install on a separate drive.

If software recovery fails, professional data recovery services are a last resort — particularly worthwhile if the file contains irreplaceable financial or legal records. The sooner you act, the better the odds.

What to Do When You've Lost Several Days' Worth of Work in an Excel File

When technical methods haven't fully worked and you've genuinely lost a significant amount of data, the situation is hard. According to ITPro, 82% of finance professionals report an emotional attachment to Microsoft Excel — so if you're feeling frustrated or anxious right now, that reaction is completely normal. Here's how to triage the situation systematically.

When Recovery Methods Haven't Worked: A Practical Checklist

1. Document what you remember — now. Open a blank Excel file immediately and start reconstructing everything you can recall: formulas, figures, structure, data ranges. Memory fades fast, and even partial reconstruction beats starting from zero.

2. Search your email. Did you ever send the file to a colleague or email it to yourself as an attachment? Check Sent Items, not just your inbox. Even an older version of the file is better than nothing.

3. Look for exported PDFs. If you ever printed the spreadsheet or exported it to PDF, that file may still exist in your Downloads folder or email history. PDFs can't be re-imported as editable Excel data automatically, but the numbers are visible and can be re-entered.

4. Check collaboration tools. Teams messages, Slack threads, and email chains sometimes include screenshots or file previews that capture data you can recover manually.

5. Contact collaborators. Anyone you shared the file with — even in read-only mode — may still have a copy in their own downloads or email.

6. Escalate to IT. If you're on a corporate network, enterprise backup systems often run independently of what you see on your own machine. Your IT team may be able to restore a version you had no idea was being backed up.

7. Consider professional data recovery services. For files containing irreplaceable financial records, legal documents, or research data, specialist recovery services have tools and cleanroom environments beyond what software can do.

How to Prevent Your Excel Files from Disappearing Again

1. Enable and shorten your AutoRecover interval. Go to File > Options > Save. Check "Save AutoRecover information every X minutes" and set it to 5 minutes. As noted by an Excel Training Specialist at Acuity Training, "By default, Excel has an auto-recover feature that saves a copy of the Excel file you are working on at set intervals" — but the default interval of 10 minutes can mean losing up to 10 minutes of work. Halving it costs nothing.

[Screenshot placeholder: Excel Options > Save tab with AutoRecover checkbox and interval field]

2. Default your save location to OneDrive or SharePoint. Saving to the cloud automatically creates version history without any extra steps. In File > Options > Save, set your default local file location to your OneDrive folder path.

3. Enable Windows File History or Mac Time Machine.

• Windows: Go to Settings > Update & Security > Backup and turn on File History, pointing it at an external or network drive.

• Mac: Go to System Settings > General > Time Machine and connect a backup drive.

4. Build Ctrl+S (or Cmd+S on Mac) into muscle memory. Save manually after every meaningful change. Set a personal rule: finish a formula, press Ctrl+S. Update a table, press Ctrl+S. It takes half a second.

5. Use date-stamped file names. Naming files like Budget_2026-03-15.xlsx makes them easy to locate by date in any search and creates a natural version trail, so an Excel file not found in one location is far easier to track down elsewhere.

6. Add an automated cloud backup service. OneDrive and File History are good. A dedicated backup service adds an independent layer that protects against account-level issues like accidental deletion of your entire OneDrive.

Frequently Asked Questions

Where did my recent Excel files go?

The Recent Files list in Excel can be cleared by crashes, Excel updates, or a change in settings. To check, open Excel and go to File > Open > Recent. The list should show your most recently accessed files. If it's empty or missing the file you need, check your OneDrive folder and your local Documents folder directly using File Explorer. The file itself is unlikely to have moved; it's more likely the Recent list that lost the reference.

How do I retrieve a missing Excel document if I never saved it?

AutoRecover is your primary option. Open Excel, go to File > Info > Manage Workbook > Recover Unsaved Workbooks, and look for a temp file matching the date and time you were last working. If that list is empty, navigate manually to C:\Users\Username\AppData\Roaming\Microsoft\Excel\ on Windows (or the equivalent Mac AutoRecovery path) and look for .asd files. Rename any match with a .xlsx extension and open it in Excel.

Can I recover an Excel file that was permanently deleted?

Yes, but act fast. When a file is permanently deleted, the data stays on disk until new data overwrites that space. Stop using the drive immediately, then download a recovery tool like Recuva or Disk Drill to a separate drive and run a deep scan. Filter results for .xlsx or .xls files. The sooner you attempt recovery after deletion, the higher the chances of getting the file back intact.

Why does my Excel file keep disappearing from the desktop?

This is almost always caused by OneDrive sync moving the file to cloud-only storage, which removes the local copy. Right-click the OneDrive icon in your system tray, go to Settings > Account > Choose folders, and make sure your Desktop folder is set to sync locally. Alternatively, the file may have been accidentally dragged to another folder. A Windows search for .xlsx files sorted by date modified will usually find it within seconds.

A disappeared Excel file is stressful, but in most cases it's recoverable and always preventable. Start with the method that matches your exact situation, work through the recovery steps without delay, and then lock in the prevention settings so this stays a one-time problem. Losing an Excel file once is painful, losing it again is avoidable.

Disclaimer

The information in this article is provided for general educational purposes only and may not apply to your specific device or situation. Technology issues can involve risks, including potential data loss. If you are unsure about any step, consider getting professional assistance. PC Laptops is not responsible for outcomes resulting from actions taken based on this content.