Recover an Excel File Saved Over? What to Try
Sometimes you can recover an Excel file after saving new content over it, but success depends on whether an earlier version or backup still exists. First check Excel’s version history and your computer’s backup or recovery options; if no prior copy was retained, the overwritten data may not be recoverable.
What happens when you save over a workbook
When you save changes to an existing workbook, Excel updates that file. Closing and reopening it does not ordinarily restore its previous contents, and pressing Undo after closing the workbook usually cannot reverse the earlier save. The practical recovery route is to find a separate copy: a cloud version, an operating-system backup, an AutoRecover file, or a manually saved duplicate.
There is an important distinction between editing a workbook and replacing it. If you changed a cell but have not closed the workbook, Undo may still restore the earlier value. If you saved the changed cell and closed the file, look for a version or backup instead. If you used Save As and created another file, the original may still be untouched; check the folder and filenames before attempting recovery.
Check Excel version history first
For a workbook stored in OneDrive or SharePoint, version history is often the easiest option, provided the service retained an earlier version and you can access it. Open the workbook, select its filename or the File tab, and look for Version History. The exact location can vary by Excel version and whether you are using the desktop app or Excel for the web. You can also locate the file in OneDrive or SharePoint and use its file menu to open version history.
- Open the version history and inspect the available dates and times.
- Open an earlier version and check that it contains the missing sheets or data.
- Save or download a separate copy before replacing the current workbook.
- If restoring the old version, confirm that you are not discarding newer changes that you still need.
Restoring an older version can replace the current version, so making a separate copy first is prudent. Version history is not guaranteed: availability depends on the storage service, account settings, retention, and whether the file was saved to that location.
Look for AutoRecover and unsaved copies
Excel’s AutoRecover feature is mainly designed to help after a crash or unexpected closure. It may offer a recovered workbook when Excel restarts, or show files under File > Info > Manage Workbook or Recover Unsaved Workbooks. Names and locations differ among Excel releases and operating systems. AutoRecover is not a reliable archive of every version, so it may not contain the workbook as it existed before a deliberate save.
If a recovery entry appears, open it and immediately use Save As to create a separate file. Compare the recovered contents with the current workbook before deciding which one to keep. If Excel did not display a recovery pane and no relevant file appears in its recovery options, do not assume that changing an AutoRecover setting now will bring back an older copy.
Use Windows or Mac backups
If the workbook was stored locally, check whether a backup system had already been configured. On Windows, right-click the file or its containing folder and check Properties > Previous Versions. This only helps when File History, backup software, or another feature has retained an earlier copy. You may also be able to restore a backed-up folder from the backup tool itself.
On a Mac, check Time Machine if it was set up and included the folder containing the workbook. In Finder, open the folder and enter Time Machine to browse available backups. The names and steps can differ by macOS version. Restore to a different location when possible, then compare the recovered file before replacing anything.
Cloud-sync services may also keep deleted or earlier file versions, depending on the service and account settings. Check the service’s version history and recycle bin or trash. A sync service can propagate an unwanted edit to other devices, so disconnecting a device is not a dependable way to recover an older version; use the service’s retained history or a separate backup.
When recovery software may not help
Recovery programs are generally better suited to finding deleted files than to reversing a saved change inside a file that still exists. An overwritten workbook may have replaced the relevant file data, and modern storage systems can make remnants unavailable. Avoid saving new files to the same drive while investigating a genuinely deleted file, since new writes can reduce the chance of recovering deleted data. For a workbook that remains present but has changed, prioritize version history and backups rather than expecting file-recovery software to reconstruct its earlier contents.
Do not download an unknown “recovery” utility or give it access to sensitive workbooks without checking its source and permissions. If the file is important and the available backups are inconclusive, consult your organization’s IT team or a reputable data-recovery professional before making further changes.
Make a safe recovery copy
Before restoring, preserve the file as it is now. Use Save As to create a copy with a distinct name, or duplicate the file in Finder or File Explorer. Store recovered versions in a separate folder and compare them carefully. This helps avoid replacing useful newer work while trying to retrieve older content.
- Check that the recovered workbook opens and that the expected worksheets, formulas, and data are present.
- Compare important cells, charts, and external links; a version may be older than you expect.
- Keep both copies until you have confirmed which one contains the information you need.
Prevent the same problem next time
Save important workbooks to a location with version history or an established backup, and periodically create a separate dated copy for files where changes are consequential. Excel’s AutoSave can save ongoing changes to supported cloud-stored files, but it is not itself a substitute for a recoverable version history. Before major edits, use Save As to make a working copy. For sensitive or business-critical files, follow your organization’s backup and retention procedures.
Frequently Asked Questions
Can I undo an Excel file after saving and closing it?
Usually not through Excel’s Undo command after the workbook has been closed. Look for version history, an AutoRecover copy, or a backup made before the change.
Where is Excel version history?
For a file stored on OneDrive or SharePoint, look for Version History from the workbook’s filename or File menu, or from the file’s menu in the storage service. Availability and menu placement vary.
Does AutoRecover restore the file I saved over?
Not necessarily. AutoRecover is primarily intended to recover work after an unexpected closure. It may have a useful copy, but it does not guarantee a snapshot from before a deliberate save.
Can I recover an overwritten Excel file without a backup?
Sometimes a cloud service or recovery copy exists even if you did not make one manually. If there is no retained version, backup, or recovery file, the old contents may be unrecoverable.
Will restoring an old version delete my current changes?
It can replace the current version. Save the current workbook separately first, then inspect the earlier copy before choosing whether to restore it.
Related
Method: the standard formula for this calculation, rounded as each result states. See how the calculators work or report an error.