File Corruption & Recovery

How to Repair an Excel Workbook Displaying an Error on Open

Chanuka Geekiyanage Oct 9, 2026 868 views

Question details

The user needs to repair an Excel spreadsheet that throws an error indicating file corruption upon opening.

How to Repair an Excel Workbook Displaying an Error When Opening

Product: Microsoft Excel
Device & OS: not provided
Scenario: Opening a corrupted or damaged spreadsheet file.
Observed behavior: Excel displays an error stating it cannot work correctly, preventing the workbook from being accessed normally.

Before you start

Before attempting repairs, it is highly recommended to make a copy of the corrupted workbook file and save it to a different folder to prevent further data loss.

Solution 1Recommended

Use the Built-in Open and Repair Feature

Excel provides a native utility designed to automatically repair and recover data from corrupted workbooks.

This built-in method is the safest first step to take when dealing with file corruption. It attempts to rebuild the corrupted data structures within the spreadsheet.

Open Excel normally

Launch the Microsoft Excel application first. Do not try to double-click the corrupted file directly from your file explorer.

Access the Open menu

Click on 'File' in the top-left corner of the interface and select 'Open'.

Select the corrupted file

Browse to the location of the corrupted workbook and click on it once to highlight it (do not double-click).

Choose Open and Repair

Click the small arrow next to the 'Open' button at the bottom of the dialog box, then select 'Open and Repair' from the dropdown menu.

Execute the repair

Click the 'Repair' button to attempt to recover as much of your work as possible. If this fails, repeat the process and choose 'Extract Data' instead to salvage values and formulas.

Data Recovery Limit: The 'Extract Data' option may lose custom formatting and macros, but it is highly effective for recovering essential raw numbers and formulas.

WPS Office Data Recovery

Open and Recover Corrupted Spreadsheets using WPS Office

WPS Office provides robust file compatibility and often succeeds in opening spreadsheets that display errors in other programs. You can use it as an effective alternative to retrieve your data.

1. Install WPS Office: Download and launch WPS Office on your computer.
2. Open the Spreadsheet app: Click on 'Spreadsheet' from the home screen and go to Menu > Open.
3. Open the damaged file: Select the corrupted Excel file and attempt to open it directly. WPS will attempt to automatically bypass the error.
4. Save a new copy: If successful, immediately go to Menu > Save As to create a new, uncorrupted copy of the file.

Easily bypass minor file corruptions when opening damaged spreadsheets.Fully compatible with all standard Microsoft Excel (.xlsx, .xls) formats.Built-in Document Recovery feature protects against unexpected crashes.Free, lightweight, and fast to install.

microsoft office alternative - wps office

Frequently Asked Questions

Why did my Excel workbook get corrupted?

Workbooks can become corrupted due to unexpected power outages, system crashes during a save process, network interruptions when saving to a shared or cloud drive, or excessively large file sizes with overly complex macros.

What happens if 'Open and Repair' doesn't work?

If the standard repair fails, you can try the 'Extract Data' option in the exact same Open menu to pull raw values and formulas. Alternatively, opening the file in a different spreadsheet program like WPS Office might bypass the strict error checks of Excel.

Can I recover an older, uncorrupted version of the file?

Yes, if you have AutoRecover enabled, you can check the AutoRecover file location (usually under File > Options > Save). You can also right-click the file in Windows Explorer, select 'Properties', and check the 'Previous Versions' tab if Windows Backup is active.

Does the 'Extract Data' option keep my cell formatting?

No, the Extract Data option prioritizes salvaging raw text, numbers, and formulas. Most visual cell formatting, charts, and VBA macros will be discarded to ensure the core data is saved safely.

Document & File Issues