Tools

Complete Guide to Microsoft's Open and Repair Feature

Open and Repair is the built-in file-recovery feature in Excel, Word, and PowerPoint. It is the first tool you should reach for when an Office file won’t open. It costs nothing, ships with every supported version of Office, and resolves the majority of routine corruption — far more often than its low profile suggests. Most users have never used it, because the menu path that exposes it is genuinely hard to find: the Open button has a small dropdown arrow next to it, and the repair option lives there.

This guide covers exactly where to find Open and Repair across current Office versions, what its two recovery modes actually do, when it works, when it doesn’t, and what to try next when it fails. It also clears up a common confusion: Open and Repair (which fixes a damaged file) is not the same as Online Repair or Quick Repair (which fix a damaged Office installation).

When to use Open and Repair

Use Open and Repair when:

An Office file fails to open with any kind of corruption error. Including “Excel found unreadable content”, “The file is corrupt and cannot be opened”, “Word experienced an error trying to open the file”, “There was a problem opening the file”, and dozens of other variants. Open and Repair is the documented Microsoft-recommended first step for all of them.

Excel or Word displays the file but the content is wrong, missing, or scrambled. Even if the file opens to something visible, Open and Repair can re-process it and frequently restores missing tables, charts, formatting, or formulas.

You inherited a file from an older Office version and it behaves oddly. Compatibility-related corruption — particularly common in .xls files opened in newer Excel versions — is exactly the kind of structural inconsistency Open and Repair handles well.

You want a free, zero-risk first try before reaching for paid tools. Open and Repair is non-destructive. It writes a recovered version to memory; the original file on disk is unchanged unless you explicitly save over it. There is no reason not to try it.

Open and Repair is not the right answer when:

The file is severely truncated or the file size is far smaller than expected. Open and Repair cannot reconstruct bytes that don’t exist. If a 10 MB file downloaded as 200 KB, the content is gone, not just damaged.

You don’t have a working Office installation. Open and Repair is part of Excel and Word themselves. If those applications won’t launch at all, you’ll need a different tool. LibreOffice is the natural free alternative; for Excel-specific repair without Excel installed, Stellar Repair for Excel or DataNumen Excel Repair are the standalone Windows options.

The file is password-protected and the password isn’t accepted. Open and Repair won’t bypass encryption. Password problems need a different approach.

How to use Open and Repair (Excel, Word, PowerPoint)

The path is identical across Excel, Word, and PowerPoint, with one critical detail: you must use the File > Open > Browse dialog. The Recent files list does not expose the Open and Repair option, even though it shows the same files.

  1. Launch Excel (or Word, or PowerPoint).
  2. Click File in the ribbon, then Open, then Browse. This opens the file selection dialog.
  3. Navigate to the folder containing the corrupted file.
  4. Click on the corrupted file once to select it. Do not double-click — that opens the file normally and skips repair.
  5. Look at the Open button at the bottom right of the dialog. It has a small downward arrow next to it.
  6. Click the arrow (not the Open button itself). A dropdown appears with several options including Open and Repair.
  7. Click Open and Repair.

A dialog appears with two options: Repair and Extract Data.

What Repair does

Repair attempts to recover the entire workbook or document with as much fidelity as possible. It rebuilds the file’s internal structure, recovers formulas, formatting, charts, embedded objects, and metadata. When successful, it produces a fully usable file that looks and behaves like the original.

This is the option to try first. It works on the majority of routine corruption.

When Repair succeeds, Excel or Word opens the recovered file in memory. Save it immediately to a new filename — this preserves the original (in case the recovery is incomplete and you want to retry with a different tool) and gives you a clean recovered version to work from.

What Extract Data does

Extract Data is the fallback. It pulls out the cell values, formulas, and text content but discards everything else: formatting, charts, pivot tables, conditional formatting, embedded objects, macros. The result is a stripped-down file containing the underlying data only.

Use Extract Data when Repair fails. Some data is almost always better than no data, and a stripped recovery can be re-formatted afterwards if the data itself is the critical part.

When Extract Data succeeds, you’ll be prompted whether to Convert to Values or Recover Formulas. Recover Formulas keeps the formula text where the engine can identify it; Convert to Values flattens everything to its calculated value. If you don’t know which to pick, Recover Formulas is the safer default — you can always flatten formulas to values later, but you can’t reconstruct formulas from flattened values.

When Open and Repair fails

If Open and Repair returns “The file cannot be repaired” or fails silently, there are a few documented escalation paths within Excel itself before reaching for external tools.

Try opening the file in Safe Mode. Hold Ctrl while launching Excel; this opens Excel without add-ins or customizations, which sometimes lets a problematic file open that otherwise wouldn’t.

Try opening with calculation set to manual. Some workbook corruption manifests as calculation errors that crash the file at open time. Open a blank workbook, go to File > Options > Formulas, set Calculation options to Manual, then try opening the corrupted file. If it opens, save it under a new name before re-enabling automatic calculation.

Try linking to the file with external references. Open a blank workbook. In a cell, type a formula referencing the corrupted file’s cells, for example ='C:\path\to\corrupted.xlsx'!A1. Excel will pull values from the corrupted file without trying to open it directly. This recovers data only, not structure, but works on files that won’t open at all.

Try saving as SYLK and reopening. This is a documented Microsoft recovery technique. If the file partially opens, save it in SYLK (Symbolic Link) format, close Excel, reopen the SYLK file, and save back as .xlsx. The SYLK round-trip filters out some kinds of structural corruption. Note that SYLK only saves the active sheet — for multi-sheet workbooks, repeat per sheet.

When all of these fail, escalate to external tools. LibreOffice Calc is the next free option — open the file in LibreOffice and save it back as .xlsx, which sometimes resolves structural problems Excel itself rejects. Beyond that, paid commercial tools like Stellar Repair for Excel and DataNumen Excel Repair are the standalone Windows options.

Open and Repair vs Office installation repair

There are two completely different “repair” features in Microsoft Office, and they are frequently confused. Knowing which one you need saves a lot of wasted time.

Open and Repair (this guide) repairs a damaged file. You launch Office, open the file with the Open and Repair option, and the application reconstructs the file. The Office installation itself is untouched.

Online Repair / Quick Repair repairs a damaged Office installation. You access it from Windows Control Panel > Programs and Features > Microsoft 365 > Change. It re-downloads or re-validates Office’s program files. This fixes problems where Excel itself crashes on launch, won’t install correctly, or has missing features — not problems with individual documents.

If your file won’t open and you reach for Online Repair, you are using the wrong tool: it will repair Office’s program files perfectly without touching the corrupted file at all. If Excel itself launches and runs but specific files won’t open, you want Open and Repair.

Limitations and known issues

Hidden in the UI. The dropdown arrow next to the Open button is small and unlabeled. Microsoft has documented Open and Repair clearly in their help pages, but the discoverability of the feature itself in the application is poor. This is the single largest reason users don’t know it exists.

Doesn’t work from the Recent files list. A file opened from the Recent menu opens normally, with no opportunity to invoke Open and Repair. You must use File > Open > Browse to access the dialog with the dropdown.

Bounded by Excel’s own corruption tolerance. Open and Repair uses Excel’s parsing engine. If the corruption is structural enough that Excel’s parser rejects the file outright, Open and Repair has nothing to work with. This is exactly when external tools — LibreOffice, Stellar, DataNumen — earn their place.

Repaired files may look different. Cosmetic elements like custom number formats, complex conditional formatting, and rare chart types sometimes don’t survive recovery in their original form. The data is preserved; the visual presentation may need re-application.

Cross-application availability is uneven. Open and Repair is documented for Excel, Word, and PowerPoint. The exact UI path may differ slightly between Microsoft 365, Office 2024, Office 2021, Office 2019, and Office 2016 — though the core “arrow next to Open” pattern is consistent across all current versions.

No equivalent for Outlook, Access, or other Office apps. Outlook PST files use Microsoft’s separate scanpst.exe tool. Access databases use Compact and Repair from within Access itself. Open and Repair is specifically for Excel, Word, and PowerPoint.

Alternatives

LibreOffice Calc and Writer are free, open-source alternatives with a more tolerant parsing engine. Opening a damaged Excel or Word file in LibreOffice and re-saving it back to the original format frequently resolves structural problems Excel itself can’t handle. The first thing to try when Open and Repair has failed. See the complete guide to LibreOffice for Word and Excel repair.

Stellar Repair for Excel is a paid Windows GUI tool. Useful when you don’t have a working Excel installation, when LibreOffice has also failed, or when you have many corrupted files to batch-process. See the complete guide to Stellar Repair for Excel.

DataNumen Excel Repair is a paid Windows tool with a stronger reputation for severely corrupted and legacy .xls files. Reach for it when all of the above have failed. See the complete guide to DataNumen Excel Repair.

Stellar Repair for Word handles equivalent corruption for .doc and .docx files when Word’s own Open and Repair isn’t sufficient.

For PDFs (a different format family entirely with its own tooling), see the qpdf complete guide or the PDF repair complete guide.

Last verified: April 2026