日本語
STEP-BY-STEP GUIDE

Excel: Recover a Damaged Workbook with Open and Repair

Troubleshooting guideSources checked: 2026-09-055 stepsFaultNote editorial team

What to do first

Retain the original, restore it by repairing it, and then extracting the value/formula.

This is a general troubleshooting guide, not an announcement of a current outage.

Affected products and symptoms

Product
Microsoft Excel for Windows
Versions and conditions
Excel for Microsoft 365 / 2024 / 2021 / 2019 / 2016
Error codes and identifiers
Open and Repair

Symptoms

  • Can't open due to corruption error
  • Can't recover automatically

Causes and conditions

Candidates include save interruption, disk/network failure, and file structure corruption.

Before you start

  • Duplicate the original
  • Check version history with OneDrive

Precautions

  • Do not directly overwrite the original
  • Formatting, shapes, and macros can be lost during extraction

Tools and official pages used in this guide

Microsoft Excel for Windows troubleshooting sequence: copy to local; Select on the open screen; repair; branch to extract; Save under a different name
Procedure overview created by FaultNote. Read the precautions and full instructions before changing settings. Read the full steps

Step-by-step instructions

  1. 01

    copy to local

    #

    If it's on a network, copy it to your PC, leaving the original intact.

    Make note of the original file's location and modification date, and give the copy a different name. If the storage device itself cannot be read, do not try to overwrite the same file over and over again, and first check the connection status of the storage destination.

    Duplicate the original workbook using Explorer and operate only the copy side. Rather than opening directly from OneDrive or email attachments, save to a short local path to separate file transfer and Excel corruption.

  2. 02

    Select on the open screen

    #

    Start Excel empty and select [File] → [Open] → [Browse] and select Copy.

    Instead of double-clicking the file to open it, use the file selection dialog that appears when you click Browse within Excel. Once you have selected your copy, look for the small arrow to the right of the Open button.

  3. 03

    repair

    #

    Select the arrow next to [Open] → [Open and Repair] → [Repair].

    At first, try to recover as much as possible with [Repair] and wait until the process is finished. If you see recovered content or a repair log, save it and check which items were repaired or deleted before proceeding.

    Official links for this step

  4. 04

    branch to extract

    #

    If Excel cannot repair it, use [Extract Data] to rescue values and formulas.

    [Extract Data] is not a method that guarantees complete recovery of the entire workbook. Even if you can retrieve values and formulas, graphs, formatting, macros, etc. may not be preserved, so you need to verify the retrieved contents.

  5. 05

    Save under a different name

    #

    Save as the original and save as a different name to match key sheets, formulas, graphs, macros, and external links.

    Don't just save your work; check important totals, formula references, and sheet counts against original documents and backups. Please leave the original file before restoration and use a file name that allows you to distinguish between the versions used for business purposes.

Check the result

  • Reopen the recovered version
  • Key values ​​can be checked against previous editions

If the problem continues

  • Open previous corruption from version history
  • Find backups and automatic recovery

Scope of this guide

Troubleshooting guide — General diagnostic and recovery procedures based on official support. It does not describe a specific current incident.

Frequently asked questions

There is no menu.

First open Excel and select from [Browse].

Is it completely back to normal?

Verify each element as there are no guarantees.

Official sources and dates

Source publication or resolution date: Not specified. Sources checked: 2026-09-05. The check date is not the date the problem first occurred. Interface labels can vary between versions and display languages.

Related troubleshooting guides

← Search English guides