How to Recover an Overwritten Excel File

An overwritten workbook may still open perfectly while containing old inputs, missing formulas, or a replaced worksheet. That makes Excel recovery more than finding the right timestamp. You must preserve the current file, retrieve likely revisions, and prove that the recovered workbook calculates correctly.

Immediate action: stop saving the live workbook. Copy it to a holding folder, record its original path and account, and take a screenshot of the missing or incorrect area.

Do not run repair, refresh external data, or accept a sync conflict until copies are secured. Each can change the workbook you are trying to evaluate.

Identify the overwrite

Define exactly what disappeared: a row range, formula column, entire sheet, PivotTable, macro, comment, or formatting rule. Record the approximate time of the good state and the bad save.

1. Confirm the filename and full path from File > Info.
2. Search for similarly named .xlsx, .xlsm, and .xlsb files.
3. Sort candidates by modified time and compare file size.
4. Check whether the expected worksheet is merely hidden.
5. Note whether the workbook uses OneDrive, SharePoint, local storage, or a network drive.

A smaller file can suggest missing media or data, but size alone does not identify the correct workbook.

Make a recovery workspace

Create a nonsynced folder named for the incident. Copy the current workbook there as current-after-overwrite.xlsx or retain its macro-enabled extension. If the workbook depends on nearby CSV files, queries, or linked workbooks, copy that project folder structure too.

Set candidate files to read-only in the file system when practical. Excel may recalculate values or prompt to update links as soon as a workbook opens, so choose Do not update until the source has been preserved.

Retrieve OneDrive or SharePoint versions

If the workbook is stored in OneDrive or SharePoint, open the correct file and choose File > Info > Version History. You can also inspect version history from the service's web interface.

1. Open the version immediately before the overwrite.
2. Confirm that the missing sheet, cells, or formulas exist.
3. Save or download it to the recovery workspace.
4. Label it with source and version time.
5. Collect an adjacent version when multiple editors were active.

Avoid restoring directly over the shared workbook during this pass. A downloaded copy lets you audit formulas without replacing legitimate later entries from colleagues.

Check Excel recovery and backups

After a crash, use File > Info > Manage Workbook > Recover Unsaved Workbooks. The Document Recovery pane may appear when Excel reopens. Save any promising item as a normal workbook in the recovery workspace before inspecting it extensively.

For a local Windows file, check Properties > Previous Versions if File History or a backup product was active. On a Mac, browse the original folder with Time Machine. A network drive may have server snapshots that only an administrator can expose.

AutoRecover is most useful for interrupted sessions. A deliberate save that replaced good content is more likely to be recoverable from version history or backups.

Validate the workbook structure

Open copies with automatic link updates disabled. Review more than the visible sheet:

• unhide worksheets and inspect very hidden sheets if the workbook uses VBA;
• use Formulas > Show Formulas to spot constants where formulas should be;
• check named ranges, tables, data validation, conditional formatting, and comments;
• inspect Power Query connections, PivotTable sources, external links, and macros;
• compare workbook calculation mode and recalculate only after a copy is secured.

Record control totals from the last known report: revenue, headcount, balance, row count, or another number that should reconcile.

Compare without trusting appearances

For manageable workbooks, place the old and current copies side by side and compare the affected ranges. For complex models, use Excel's available comparison tooling or an approved audit process in your organization. Do not paste an entire old worksheet over a newer one until you know which later entries would be lost.

Values can look identical while formulas differ. Conversely, displayed totals can differ only because one workbook has not recalculated. Inspect formula text, references, and input timestamps before choosing.

Build a merged workbook

When the older version has good formulas but the current file has newer data, make a third workbook named recovered-merged.xlsx.

1. Copy the current workbook as the merge base.
2. Restore only the confirmed missing formulas, ranges, or sheets from the historical copy.
3. Reconnect approved external sources.
4. Recalculate the copy.
5. Reconcile control totals and test representative formulas.
6. Have the workbook owner review the result.

Keep macro-enabled workbooks in .xlsm format. Saving as .xlsx can remove VBA content.

Choose the right source

Stop before the evidence changes

Escalate financial reporting, payroll, tax, regulated, or litigation workbooks before performing a live restore. Preserve the current workbook, downloaded versions, source path, account, event time, and screenshots. If the storage location is managed, administrators may have retention snapshots or audit history that ordinary users cannot see.

Final workbook check

Close Excel, reopen the merged copy, and verify sheet count, formulas, named ranges, links, queries, macros, comments, and print areas. Reconcile at least two independent totals. Only then place the recovered workbook back into production under a new filename and archive the original candidates.

Sources and further reading

• Microsoft Support: Restore a previous version of a OneDrive file
• Microsoft Support: Save, back up, and recover Office files
• Microsoft Support: What is AutoSave?