Recover Overwritten Excel File: 6 Ways That Work

If you accidentally saved over an Excel file and lost your previous version, you can usually recover it using built-in Excel features, Windows tools, or file history—but you need to act quickly and know which method fits your situation. This guide explains the six most effective recovery methods, how they work, and what to do when they fail.

How Excel Handles Overwritten Files

When you save over an existing Excel workbook, the original file is replaced on disk. However, Excel and Windows often keep hidden copies or versions that you can access:

• AutoRecover: Excel saves temporary snapshots of open workbooks at set intervals (default every 10 minutes). These are stored in a hidden folder and can be used to restore unsaved or overwritten changes.
• Version History (OneDrive/SharePoint): If your file is stored in OneDrive or SharePoint, the cloud service automatically keeps a history of previous versions. You can view and restore any of them.
• File History (Windows): Windows File History can keep copies of files in user folders, but only if you enabled it before the incident.
• Previous Versions (Windows Restore Points): Windows creates restore points that may include older copies of files, but this is not reliable for every file.

Important: The longer you wait, the more likely these temporary copies will be overwritten by new data. Stop using the file immediately after you realize the mistake.

Method 1: Use Excel’s Built-in Version History

If your file is saved to OneDrive, SharePoint, or Microsoft 365 cloud storage, version history is the fastest and most reliable method.

1. Open the overwritten file in Excel.
2. Click File > Info.
3. Look for the Version History button (or “Browse version history� in older versions).
4. A sidebar will list all previous versions with timestamps. Click on one to open it in a separate window.
5. Compare the content, then click Restore to replace the current version, or copy the data you need.

This method works only if the file is stored in a location that supports versioning. Local files on your hard drive do not have this feature.

Method 2: Recover from AutoRecover Files

Excel’s AutoRecover feature saves temporary copies of open workbooks. If you overwrote a file, the AutoRecover folder may still contain an earlier snapshot.

1. Open Excel and go to File > Open.
2. Click Recent and then scroll to the bottom to find Recover Unsaved Workbooks (or “Recover Unsaved Documents� in some versions).
3. In the dialog that opens, look for files with the .xlsb or .xlsx extension and a name like “WorkbookName_autorecover�.
4. Select the most recent one that predates your overwrite and open it.
5. If you find the right version, save it with a new name to avoid overwriting again.

If you don’t see the file there, you can manually navigate to the AutoRecover folder. The location varies by Excel version, but a common path is:

%AppData%\Microsoft\Excel\ (for Windows) or ~/Library/Containers/com.microsoft.Excel/Data/Library/Application Support/Microsoft/Excel/ (for Mac).

Note: AutoRecover only works if the file was open in Excel when the overwrite happened. If you closed the file and then reopened it to make changes, the earlier version may still be in the AutoRecover folder.

Method 3: Use Windows File History or Previous Versions

Windows has two built-in features that can help recover overwritten files:

• File History: If you have File History enabled (Settings > Update & Security > Backup), you can restore an older copy of the file from the backup drive. Right-click the file in File Explorer, select Properties, then the Previous Versions tab. If File History is turned on, you’ll see a list of available versions.
• Restore Points: Windows creates restore points before major changes (like software installations). These may contain older copies of files, but they are not guaranteed to have the exact version you need. To access them, right-click the file, go to Properties > Previous Versions, and look for versions labeled “From restore pointâ€�.

If you don’t see any previous versions, it means neither File History nor System Protection was enabled for that drive. Unfortunately, without a backup, recovery becomes much harder.

Method 4: Check Temporary Files and Shadow Copies

Excel creates temporary files (with a ~$ prefix) while a workbook is open. These are usually deleted when you close the file, but sometimes they remain. Also, Windows Volume Shadow Copy (VSS) may keep snapshots of files even if you haven’t set up File History.

1. Open File Explorer and navigate to the folder where your Excel file is stored.
2. Enable “Hidden items� in the View tab.
3. Look for files starting with ~$ followed by your workbook name. These are temporary lock files, but they sometimes contain data.
4. If you find one, rename it to .xlsx and try opening it in Excel.
5. For shadow copies, you can use the Previous Versions tab as described above, or use the command prompt with vssadmin list shadows (requires admin rights). However, this is advanced and usually not necessary for most users.

This method is hit-or-miss. Temporary files are often empty or corrupt, but it’s worth a try if other methods fail.

Method 5: Use Third-Party File Recovery Software

If you have no backups and the above methods fail, third-party recovery tools may be able to scan your hard drive for remnants of the overwritten file. These tools look for deleted or overwritten data at the disk level.

• How it works: When you overwrite a file, the old data isn’t immediately erased—the disk sectors are marked as free and can be overwritten later. Recovery software scans for these remnants.
• Important: The more you use the computer after the overwrite, the higher the chance the old data is permanently gone. Stop using the drive immediately.
• Examples: Recuva, EaseUS Data Recovery Wizard, Disk Drill (these are well-known, but there are many others).
• Success rate: It varies. If the file was large and the disk is not heavily used, you might recover a partial or full version. But this is not guaranteed.

Be cautious: some free tools may install additional software or require payment for full recovery. Always download from official websites.

Common Mistakes and What to Avoid

Many people accidentally make the situation worse. Here are the most common pitfalls:

• Continuing to work on the file: Every save or edit increases the chance that the old data is overwritten. Close the file immediately.
• Ignoring AutoRecover settings: Check that AutoRecover is enabled and set to a short interval (e.g., 5 minutes) to minimize data loss in the future.
• Not saving a backup: The simplest way to recover is to have a backup. Use OneDrive, an external drive, or a file history tool.
• Assuming version history works for local files: Version history only works for cloud-stored files. For local files, you need File History or a backup.

Frequently Asked Questions

Can I recover an overwritten Excel file if I don’t have OneDrive or File History?

Yes, possibly. Excel’s AutoRecover folder may still contain a temporary copy, even for local files. Check the AutoRecover location as described in Method 2. If that fails, third-party recovery software might find remnants, but success is not guaranteed.

Does Excel keep a history of all versions of a file?

Only if the file is stored in OneDrive, SharePoint, or another service that supports versioning. Excel itself does not keep a full history for local files—only the current version and the AutoRecover snapshot (which is temporary).

What is the difference between AutoRecover and Version History?

AutoRecover is a local feature that saves temporary copies of open workbooks at intervals. Version History is a cloud feature that stores every saved version of a file in OneDrive or SharePoint. AutoRecover is for unsaved or crashed files, while Version History is for tracking changes over time.

How long does Excel keep AutoRecover files?

AutoRecover files are kept until you close the workbook or Excel is closed normally. They are deleted when you save the file and exit. However, if Excel crashes, the AutoRecover files may remain for a few days, depending on your settings. You can change the AutoRecover save interval in Excel Options.

Can I recover an overwritten file from a USB drive?

Yes, but it’s harder. USB drives often don’t have File History or shadow copies. Your best bet is to use third-party recovery software that can scan the USB drive. The success rate depends on how much the drive has been used since the overwrite.

What should I do if I accidentally overwrite a file and then save it again?

If you save again, the old version is likely gone. However, you can still check the AutoRecover folder for any snapshot taken before the first overwrite. If you have OneDrive, version history will show all versions, including the one before the second save.

Related

• How to Make a Facebook Page: Complete Guide
• Fix Switch Sports Motion Control & Joy-Con Tracking
• Pixel Buds 2 Audio Cutout Issues: Fixes That Work