How to Recover Deleted or Unsaved Excel Files

Losing an Excel file can feel alarming, especially after a crash, an accidental deletion, or a mistaken click on “Don’t Save.” In many cases, the workbook is not immediately gone. Excel, Windows, OneDrive, File History, the Recycle Bin, and backup tools may each hold a different copy. The best recovery method depends on what happened and where the file was stored.

This guide is for ordinary Windows PC users who are trying to recover files from their own computer, storage device, or account. It focuses on safe, lawful steps. It does not explain how to bypass passwords, encryption, account security, or access controls. If a workbook is protected, use the authorized account, password, or administrator process that belongs to you or your organization.

Most importantly, if a deleted file may still need recovery, stop writing new data to that drive. Do not install large programs, copy videos, download games, or repeatedly save new files there. New data can overwrite the unused space where the deleted workbook’s contents remain. Recovery is not the same as backup: recovery tries to find a lost copy after something went wrong, while a backup is a separate copy made in advance for that purpose.

First, Identify What Happened

Unsaved workbook: You were editing a new workbook or an existing one, and Excel or Windows closed unexpectedly.

Deleted workbook: You deliberately or accidentally deleted a file, possibly by pressing Delete or emptying the Recycle Bin.

Overwritten workbook: You saved newer content over an older version.

Missing workbook: The file was not necessarily deleted; it may have been moved, renamed, stored in another folder, or hidden by a sync problem.

Damaged workbook: Excel finds the file but reports that it cannot open or read it.

Unavailable cloud copy: A file in OneDrive, SharePoint, or another service may be online-only, unsynced, or removed from that service’s recycle area.

Write down the likely file name, folder, approximate last saved time, and drive. Common Excel extensions include .xlsx, .xlsm, .xls, and .csv.

Stop Making Changes When Deletion Is Possible

If the workbook was deleted from a local drive, close unnecessary applications and avoid using that drive. Windows may write temporary data even during normal use, so do not treat a recovery attempt as guaranteed. If the lost file is on a removable USB drive or memory card, safely eject it and do not save anything else to it.

If the drive is making clicking noises, repeatedly disconnecting, showing read errors, or disappearing, stop experimenting. Continued use can worsen a hardware failure. A professional data-recovery service may be safer, although it can be expensive and cannot promise success. For an important business or legal file, ask an IT professional before installing recovery software.

Check Excel’s Built-In Recovery Options

Excel can keep temporary recovery copies while you work. The exact wording and location varies by Excel version, Windows edition, license, and whether you use a Microsoft 365 account, a perpetual Office license, or a work-managed installation.

Recover an unsaved workbook

Open Excel without opening another workbook first.

Select File, then Info.

Look for Manage Workbook, Manage Document, or a similar option.

Choose Recover Unsaved Workbooks.

Review the files by date and time. Open the most likely one.

If it contains your work, immediately use Save As and save it to a new, clearly named folder.

Another route in some versions is File > Open > Recent > Recover Unsaved Workbooks. If you find a temporary file, save it as a normal .xlsx or another format you intentionally need. Do not overwrite the only copy while checking it.

Check AutoRecover settings

To see where Excel may store recovery files, open File > Options > Save and look for AutoRecover file location. AutoRecover is mainly for crash recovery, not a complete version history, and a copy may be missing if the option was disabled or temporary data was cleaned up.

Search Windows Before Assuming the File Is Gone

A workbook may still exist under a different name or folder. Open File Explorer and search the likely drive for .xlsx, then repeat for .xlsm, .xls, and .csv if appropriate. Sort results by Date modified and inspect files around the time you last worked.

Also search for the original name without its extension. Check Documents, Desktop, Downloads, project folders, attached drives, and any authorized work folder.

Check Excel’s recent list under File > Open > Recent. A recent entry that fails to open may still reveal the original folder. In File Explorer, turn on file-name extensions so that a misleading name such as budget.xlsx.tmp is easier to recognize. Do not rename a file just to make it look like an Excel workbook unless you know what it is; first make a copy and work on that copy.

Look in the Recycle Bin

For a normal deletion from an internal drive, open the Windows Recycle Bin on the desktop. Search by name, type, or deletion date. Right-click the likely workbook and choose Restore. Windows normally returns it to its original folder.

If you cannot see the Recycle Bin, use the Start search to open it or check desktop icon settings. A file may not be there if it was deleted from a USB device, a network location, a cloud service, or with a command that bypasses the bin. The Recycle Bin also may have been emptied automatically or manually. If you restore a file, open it and confirm the contents before deleting any duplicate.

Check OneDrive, SharePoint, and Version History

If the workbook was stored in OneDrive or SharePoint, check both the synchronized folder on the PC and the service’s web recycle area using the account authorized to access the file. A cloud file can be online-only, paused, not fully synchronized, or connected to a different Microsoft account.

For an existing workbook, right-click it in File Explorer and look for Version history, or use the equivalent option in the cloud service. Version history can restore an earlier state after an accidental overwrite. Before restoring, consider downloading or copying the current version so that you do not lose newer changes. In a shared work folder, restoration may affect other people, so coordinate with the owner or administrator.

Cloud recycle bins have retention rules that depend on the service, account type, organization policy, and administrator settings. Verify the authorized account rather than trying to defeat account controls.

Restore From Windows or Organization Backups

If the workbook was backed up before it disappeared, restore a copy instead of trying to reconstruct it. File History may provide older versions when it was enabled and configured. In File Explorer, browse to the original folder, right-click it, and select Restore previous versions if that option is available. Review dates carefully and choose Open or Copy before using Restore, when possible.

Other legitimate sources include a Windows backup image, external backup drive, company backup system, or organization retention feature. Contact the authorized backup manager with the folder, name, and approximate date; Windows or Office installation alone does not prove a backup exists.

The table below summarizes which path to try first.

Use File-Recovery Software Carefully

If the workbook is permanently deleted and no backup exists, recovery software may scan for remnants. Choose a legitimate vendor and check its license, privacy terms, supported file systems, and current limits or price before installing.

The most important safety rule is to install the recovery program and save recovered files on a different physical drive whenever possible. Installing it on the same drive can overwrite the deleted workbook. For example, scan an internal drive but save recovered files to an external drive. If the only drive is the one containing the lost file, use another computer or ask a professional.

A scan may display a file name without recovering a usable workbook. Preview the result if the software offers that feature, recover to a new folder, and open the copy in Excel. Do not repeatedly scan, repair, and save over the same source. Stop if the drive shows signs of physical failure.

Recovery software cannot lawfully or safely bypass encryption, passwords, or account protections. It may also fail when a solid-state drive has already reclaimed deleted blocks through its storage-management process. Treat any “guaranteed recovery” claim skeptically and avoid tools that request unnecessary account access or ask you to disable important security protections.

Repair a Workbook That Opens With Errors

Sometimes the file is present but damaged. Make a backup copy first. In Excel, choose File > Open > Browse, select the workbook, click the arrow beside Open, and look for Open and Repair if your version provides it. Try Repair first; if that fails, try Extract Data to recover values and formulas that can still be read.

You can also try opening the copy in another compatible spreadsheet application, but formatting, macros, external connections, and formulas may change. A .xlsm workbook can contain macros, so do not enable macros unless you trust the file and understand what they do. If the workbook opens, save a new copy and compare important sheets, formulas, charts, and pivot tables with what you remember.

Practical Tips for Safer Recovery

Keep the original storage device unchanged whenever possible; perform work on copies.

Use a separate destination drive for recovered files.

Prefer built-in Windows, Excel, and authorized cloud recovery features before random utilities.

If a work or school account is involved, contact the authorized administrator rather than changing security settings.

Scan recovered files with your normal security software before sharing or opening them elsewhere.

Check macros and external links before enabling content in a recovered workbook.

To prevent a repeat, save important work in a known folder, use suitable AutoRecover settings, and maintain an independent backup. A synchronized folder is not automatically a backup: deletions can synchronize too. Keep one copy separate from the computer and test that it restores correctly.

What Can Vary on Your PC

Menus differ between Excel desktop, Excel for the web, Windows editions, and managed installations. Options may require a Microsoft 365 subscription, Office license, signed-in account, OneDrive storage, or administrator permission. Security software, storage hardware, and VPN features also vary; a VPN does not recover a local file but can affect work-network access. If a menu is missing, look for its equivalent rather than changing security controls.

Conclusion

Match the method to the loss: check Excel recovery for an unsaved workbook, stop writing to the drive and check the Recycle Bin after deletion, inspect version history after an overwrite, and search folders for a missing file. Use recovery software only as a last resort, saving results elsewhere.

Recovery may succeed, but it is never a substitute for a tested backup. Once your workbook is restored, verify the important data, keep a separate copy, and establish a backup routine that fits how you use your PC. Always work only with your own files or files you are authorized to manage, and ask qualified support for help when the device itself appears to be failing.