Recover Overwritten Excel Files on Windows 11

An overwritten workbook is a different problem from a deleted one. The file still exists, so there is nothing in the Recycle Bin, and the contents have been replaced in place. Whether the old data is recoverable depends almost entirely on how the save happened: an edit that has not been closed, an autosaved cloud copy, a shadow copy on the volume, or only the new data written over the old sectors. Check the options in the order below, from fastest and most certain to slowest and least certain.

Table of Contents
  1. What "overwritten" means in Excel
  2. Undo while the file is open
  3. Autosave and recovery files
  4. Version history and Previous Versions
  5. Disk scan and prevention
  6. Recommended tools

What "overwritten" means in Excel

Excel writes a workbook by replacing the file, not by editing it in place. The steps it goes through determine what is left behind.

Undo while the file is open

Step 1. Do not close Excel. Closing flushes the file and clears the in-memory history.

Step 2. Press Ctrl + Z repeatedly until the data returns. If AutoSave is off and you have saved, this will not reach back past the save.

Step 3. If the change is already saved but the file is still open, use File then Info and look for Version History or Manage Workbook. Both can surface an earlier copy without closing the file.

Step 4. Use Save As with a new name before doing anything else, so that the damaged version is not overwritten again.

Autosave and recovery files

Step 1. Check the Excel AutoRecover folder. Open File Explorer, paste %AppData%\Microsoft\Excel into the address bar, and look for files with an .asd extension or folders named after the workbook. Files here are usually unsaved or crashed-session copies.

Step 2. Check the workbook's own folder for .tmp files with a similar name and a recent timestamp. Excel sometimes leaves a temp copy during a save.

Step 3. Open the candidate in Excel and compare it with what you expect. If it is the right version, save it under a new name immediately.

Step 4. Ignore files that begin with ~$. Those are lock files that record who has the workbook open; they contain no spreadsheet data.

Check unsaved work

If Excel closed unexpectedly and offered to recover files but you dismissed the prompt, reopen Excel and look at File then Info then Manage Workbook then Recover Unsaved Workbooks. The list survives until the files are deleted or the folder is cleaned.

Version history and Previous Versions

Step 1. For a cloud-saved workbook, right-click the file in File Explorer and choose Version history. Pick the version from before the overwrite and restore it.

Version history for an Excel workbook

Step 2. For a local workbook, right-click it, open Properties, and select the Previous Versions tab. Any entry there comes from a restore point, File History, or a third-party backup agent. Open the entry, then copy the workbook out rather than restoring the whole volume.

Restore a previous version of the workbook

Step 3. Check File History if it was ever enabled: Control Panel then File History then Restore personal files. The copy of the workbook from an earlier timestamp will be in the dated folder.

Restore files from File History

Disk scan and prevention

When none of the above yields a usable copy, a recovery tool can sometimes find an older version of the workbook in unallocated space. It works best when the overwrite was recent, the file was large, and the drive has not been busy since.

Step 1. Stop using the drive that held the workbook. Every new file written can occupy the sectors you are trying to recover.

Step 2. Scan the volume with a recovery tool and filter the results by extension and modification date. Recover to a different drive.

Step 3. Expect partial results. An overwritten file is the hardest recovery case there is, and success is not guaranteed even with the best tool.

Prevent the next overwrite

Recommended tools

Two Qiling tools cover the two halves of the problem: getting a workbook back after it has been saved over, and making sure the next overwrite costs you nothing.

Recover an overwritten workbook with Deep Data Recovery

Deep Data Recovery scans the volume for workbook remnants, lets you preview what it finds before recovering anything, and restores Word, Excel, PDF, photo, and video files to a different drive. Because a saved-over workbook may already be gone from the disk, treat the scan as a chance rather than a guarantee.

Keep scheduled backups with Disk Master Professional

Qiling Disk Master Professional can back up the folders that hold your workbooks on a daily or hourly schedule, keep several previous versions, and restore a single file without touching the rest of the drive. Point the task at your project folder or a synced OneDrive directory, and the next accidental save becomes a copy you can roll back.

Related Articles


Is this information helpful?     

What can we do to improve this information? (Optional)
Refresh Please enter the verification code!


QilingTech uses cookies to ensure you get the best experience on our website.  Learn more  Got it