Overwrote an Excel file? Where to look for the previous version
The workbook still opens, but the values you need are gone. An empty Unsaved Workbooks folder does not tell you whether an older copy exists elsewhere.
- For a workbook kept in OneDrive or SharePoint, look for an earlier copy in Version History. A file kept only on your PC needs an existing backup or a surviving recovery copy; signing into Excel does not create a history for it.
- Keep a copy of the current workbook before restoring anything. If it contains useful later edits, you can compare it with the older file and recover individual entries instead of replacing the entire workbook.
- Recover Unsaved Workbooks is not a history of every successful save. If no suitable copy survives, check attachments and colleagues’ copies, then use source records to rebuild what is still missing.
If you saved a mistaken edit, reopening the workbook simply loads that edited content. AutoSave can put you in the same position even when you never pressed Save. To recover the earlier content, you need a version or copy that still contains it.
There is also a second problem: the current file may contain work worth keeping. Restoring yesterday’s workbook could recover a deleted formula while removing today’s entries. Start by preserving the current file, then decide how much of the earlier version to bring back. The menu instructions below focus on Excel for Microsoft 365 on Windows 11.
Find the file you actually edited
Check the workbook’s location through its title or File → Info. A downloaded attachment, a local working copy and a shared company workbook can all have the same name. The history you need belongs to the file that received the unwanted changes.
Microsoft 365 Version History requires a file stored in OneDrive or SharePoint in Microsoft 365. Merely being signed into an Office account does not give a separate local workbook that history. A Desktop or Documents folder may be connected to OneDrive, so check the actual location rather than deciding from the folder’s familiar name. If it is synced, find the corresponding file in OneDrive in your browser.
| File you worked on | Where to look | What must be available |
|---|---|---|
| OneDrive or SharePoint original | That file’s Version History | A retained version from before the mistake |
| File stored only on the PC | File History or another existing backup | A backup that covered its folder before the overwrite |
| Work closed without saving or interrupted by a crash | Excel recovery files | A surviving copy containing the missing work |
| Downloaded email attachment | The original message | The attachment as it was sent, without your later additions |
Use File → Save a Copy, or Save As for a local workbook, to preserve the current state under a new name. Names such as Prices_before_recovery.xlsx and Prices_earlier_copy.xlsx help distinguish the copies. Keep the original format and make an actual copy rather than just renaming the only file you have.
Open an earlier cloud version before restoring it
After saving your backup copy, return to the original cloud workbook to look for its history. In the desktop app, select its title and Version History, then open a version from before the unwanted change. It opens separately so you can inspect its contents. Look for the missing formula or value itself: a reassuring timestamp is not proof that the file was still correct.
You can also select the original file in OneDrive in your browser, right-click and choose Version history. OneDrive’s restore command is in the menu beside the chosen version. Check that you are in the correct personal or work account. If a company file has no visible history, ask its owner or administrator to check the location and document versioning settings.
Do not expect a separate entry for every moment you edited. AutoSave saves changes frequently, while new history entries are created periodically. The most recent entry before you noticed the problem might already contain it. Inspect another available version if necessary.
For a shared workbook, coordinate with the people editing it before rolling anything back. Microsoft says to wait until everyone has finished co-authoring before restoring a past version. Have one person handle the recovery. Anyone with unsynced changes or an upload error should preserve their work separately rather than assume it is included in the cloud copy.
Restore the workbook or recover selected entries?
Restoring a version replaces the current workbook with the selected earlier state. It does not identify and reverse only the mistaken edit. Microsoft’s Excel restoration instructions warn that updates made after the selected version will be absent. A full rollback makes sense when you want that entire state back and have accounted for subsequent work.
That is a broader change than necessary if only one price is wrong. Consider this invented price list, with all amounts in Korean won. Product P-17 was accidentally changed from ₩15,000 to ₩1,500. P-28 was deliberately increased from ₩22,000 to ₩24,000 later that day.
| Product | Morning copy | Current workbook | Required result |
|---|---|---|---|
| P-17 | ₩15,000 | ₩1,500, entered incorrectly | ₩15,000 |
| P-28 | ₩22,000 | ₩24,000, approved increase | ₩24,000 |
Keep the current file untouched and make a working copy for the repair. Find P-17 in both the working copy and the earlier file, then bring over that price. Leave P-28’s valid increase in place. Restoring the morning workbook wholesale would also roll back P-28.
Match product codes rather than row numbers: someone may have sorted the table since the earlier version. If a code occurs more than once, use the customer, effective date or other identifying fields to locate the correct record. An older price is not automatically the right price; check the quote or approval record when the intended value is uncertain.
For a recovered input number, Home → Paste → Values lets you bring over the value. However, pasting values from a formula cell transfers its result, not its calculation. That is unsuitable if you need the restored cell to keep calculating when other inputs change.
For a missing formula, inspect the expression and its references in the repaired workbook. Relative references can change when formulas are copied. Check which cells and workbook names the formula refers to, especially when bringing it into a different row or file. A plausible displayed result alone does not establish that the calculation has been repaired.
Finish the example by checking both outcomes: P-17 should be ₩15,000, and P-28 should remain ₩24,000. In a real workbook, also compare later additions and changes on other sheets with the preserved current copy. Once the repair is verified, apply the intended correction to the team’s agreed working file. Avoid leaving people entering new data into competing copies.
Look for local backups and recovery files
For a file kept only on the PC, Windows File History is useful only if it had already backed up the relevant location. Connect the backup drive if necessary. In File Explorer, right-click the original folder and choose Restore previous versions. Inspect a candidate with Open in File History.
To recover it elsewhere, expand Restore and choose Restore to…. Microsoft warns that restoring in place replaces the current file or folder and cannot be undone. Recovering to a separate location gives you a copy to compare. Enabling File History now will not manufacture a backup from yesterday.
If the workbook lived on a company file server, ask the administrator about existing backups. Provide the original path, when you last saw the correct content and when the overwrite occurred. The availability of a server backup depends on that organisation’s setup; an empty list on your PC does not answer that question.
Excel’s AutoRecover is a different route. With AutoRecover enabled, Microsoft’s recovery guide directs you to File → Info → Manage Workbook for a version marked as closed without saving, or to Recover Unsaved Workbooks. Open a relevant file and save it separately after checking its contents. This is not an archive of every version you deliberately saved over.
An empty recovery folder therefore does not settle the whole search. Check the original cloud file or existing backups as appropriate. If none of those locations contains the missing material, repeatedly reopening the same recovery menu will not recreate it.
When no earlier copy turns up
Look for an attachment you sent, a copy a colleague received or the source records behind the spreadsheet. Treat each as evidence for a particular period. Last week’s attachment may recover a formula, but it will not include entries added after you sent it.
In the price example, an approved quote might establish P-17’s intended price even when the old workbook is unavailable. A PDF containing only a grand total would not establish each underlying price or reconstruct the formulas. Recover what the surviving records support, and keep unresolved entries visible for checking instead of filling them with guesses.
For the next reporting cycle, change when you create the new file. Editing last month’s workbook and using Save As at the end can leave the original changed when AutoSave is active. Microsoft recommends Save a Copy before editing an existing file you intend to reuse. Confirm the new name in the window before replacing the old figures.
Keep the pre-recovery workbook and the earlier copy until the missing content and valid later changes have both been checked. The useful result is a workbook your team can continue using, with the recovered information in place and the subsequent work still accounted for.