Preserve and recover a corrupted workbook

Quick answer: Preserve the unreadable file, make a separate working copy, then try Excel’s Open and Repair on that copy. Treat anything it returns as a candidate requiring validation, not proof that the original workbook has been restored completely.

Choose the right problem first

This documentary workflow covers already licensed Windows desktop Excel for Microsoft 365, 2024, 2021, 2019 and 2016, the editions listed in Microsoft’s repair guidance. It is not a free-web feature claim. No damaged file was opened, repaired, uploaded or deliberately created for this guide, and no successful recovery is asserted.

An unreadable workbook and an unwanted edit are different problems. If the workbook opens but someone changed a number, use earlier workbook versions to investigate available history. If it opens but a cell is wrong, start with Excel troubleshooting. An access-denied message alone does not establish corruption; contact the authorized owner rather than bypassing protection.

Preserve evidence and candidates

Before a repair attempt, retain the original file unchanged in an authorized location. Record its name, size, time, storage location, exact error and the last known successful opening. Work only on a duplicate, with a name such as Budget-repair-attempt-01.xlsx. Preserve any backups and earlier candidates separately too: one imperfect candidate may contain information another lacks.

If the only readable state is still open and contains unsaved work, do not close it merely to follow this procedure. First consider how to preserve that state without replacing the original. Do not accept an overwrite prompt as a routine recovery step.

Microsoft advises using a different disk or a local disk when disk/network errors prevent opening. Here, prefer a copy in an authorized location while retaining the source. If copying fails, stop and resolve the storage problem; do not repeatedly save over the only copy. Keep organization-controlled data within its approved storage boundaries. This guide requires no online repair service or third-party upload.

Try the documented repair route on a copy

Microsoft describes automatic File Recovery when corruption is detected, but notes that it may not start. Its manual route is:

1. In desktop Excel, choose File > Open. The documentation specifically describes selecting a location and Browse for Excel 2016; newer editions may present the file picker differently.
2. In the Open dialog, select your working copy, not the preserved original.
3. Use the arrow beside Open, then Open and Repair.
4. Choose Repair. If unsuccessful, Extract Data is the documented fallback for values and formulas.

Use a fresh duplicate of the preserved original for a separate fallback attempt. Keep each candidate under a new name and preserve its existing file type where possible; do not replace any previous candidate. Record what Excel reports and which path produced the file. An extracted result is not a promise of intact formatting, charts, links, macros or other workbook behavior. Microsoft does not guarantee successful recovery.

Worked decision: a plausible total is not enough

This is a hypothetical review exercise, not an application recovery result. Suppose an independently retained report identifies these three rows in a small budget:

Item	Quantity	Unit cost	Expected line amount
Paper	4	12	48
Toner	2	75	150
Labels	5	8	40

The expected total is 238. The original workbook specification calls for each line amount to be a formula multiplying that row’s quantity and unit cost. The retained report is a comparison source, not evidence of what any repair tool will recover.

Consider three possible candidates:

• Candidate A contains all three rows and total 238, but its line amounts are constants. It may be useful as a values-only salvage copy; it is not yet a recovered calculation model.
• Candidate B contains only Paper and Toner, totaling 198. A missing Labels row explains the 40 shortfall. Do not invent the missing data solely to make the total balance.
• Candidate C has all three expected formulas and total 238. That passes this tiny arithmetic check, not a whole-workbook check. Other sheets, links or features might still be absent.

A useful follow-up check on a disposable copy of a model candidate changes Paper quantity from 4 to 5. The expected Paper amount becomes 60 and total 250. A values-only candidate stays at 48/238 unless someone edits it; that distinguishes preserved results from working formulas. Independently checked arithmetic does not establish native recalculation behavior.

Validate before returning a candidate to use

Inventory expected worksheets and their names, record counts, representative identifiers, formulas and control totals against trustworthy records. Inspect important named ranges, charts, links and any essential automation without enabling untrusted content. A file merely opening is not a sufficient acceptance test. Save under a new candidate name, reopen that candidate if possible, and repeat the important checks.

If nothing usable emerges, retain the original and all candidates, record the failed route, and seek help from the authorized file owner or IT team. Share only an approved, minimized example if support needs one. Do not keep repeating a failed operation on the only surviving copy.

Avoid treating a conversion to CSV or another reduced format as full recovery. This guide intentionally stops short of lossy conversions, macros or external repair tools. Replacing a shared production workbook should be a separate, coordinated decision after validation, not the final click in an experiment.