How to Repair A Corrupted Workbook? Check Your Full Guide!

Does your Excel Workbook get corrupted? If you are looking for a useful way, well, you are lucky in there. On this page, these methods are built around a damaged workbook, we will teach you how to repair a corrupted workbook in Windows 10. Join us and keep reading.

 Download for Win Recovery Rate 99.7%
 Download for Mac Trustpilot Rating 4.4

Table of Contents

"I had by mistakenly Shift + Del my excel document which was of high importance. I tried to recover the file using a software and I got the file back, but when I am trying to open the file. It shows the corrupted file error message. Can anyone please help me on this issue."

There are no more frustrating things than a corrupted workbook while in a hurry you are planning to use it. How to get a reliable solution without any cumbersome steps and get the workbook back with data loss? This article will describe the culprits behind the file crash and how to repair the Excel workbook with repairing and manual ways.

Quick Navigation:

Why Does My Excel File Getting Corrupted
How to Repair A Corrupted Workbook with EaseUS Data Recovery Wizard
How to Fix A Corrupted Work Manually
Bonus Tips: How to Avoid Excel Files from Corrupted

Why Does My Excel File Getting Corrupted

How does your workbook get corrupted? The reasons are not hard to fathom. Check it as follows:

  • Unexpected computer shut down: Due to a power outage or system crash, your data fail to access.
  • Virus or malware attack: File is the best prey for malware. The workbook is vulnerable to viruses.
  • Unexpected Excel crash: If you haven't updated your excel app or missing some essential update, your software is likely to crash at an unknown moment.
  • Bad sectors on hard drive: If you haven't optimized your hard drive, your disk may exists some bad sectors, which accumulate over time and damage your excel files at the end.

Some tutorials may advise you to check previous backup files from file history or other locations. Seems useful but most times you can not find what you want. Because if you have updated the .xlsx files, again and again, your backup may not contains the latest data. So the reliable way to reach your value file is to use an Excel repairing tool and some manual ways.

How to Repair A Corrupted Workbook with EaseUS Data Recovery Wizard

To fix a corrupted excel workbook, we highly recommend an all-purpose file repair software - EaseUS Data Recovery Wizard. It can recover data from various scenarios like unexpected power failure, virus attack, internal/external hard drive crash, permanently delete, and more.

You can download the software to recover and repair your damaged excel workbook:

 Download for Win Recovery Rate 99.7%
 Download for Mac Trustpilot Rating 4.4

Step 1. Launch EaseUS Data Recovery Wizard, and then scan disk with corrupted documents. This software enables you to fix damaged Word, Excel, PPT, and PDF files in same steps. 

select the disk with corrupted documents

Step 2. EaseUS data recovery and repair tool will scan for all lost and corrupted files. You can find the target files by file type or type the file name in the search box. 

find corrupted documents

Step 3. EaseUS Data Recovery Wizard can repair your damaged documents automatically. After file preview, you can click "Recover" to save the repaired Word, Excel, and PDF document files to a safe location.

repair corrrupt documents

We've mentioned more post about excel file repairing, check the article to get more online tool:

related articles

Free | How to Repair Corrupted Excel Files with Excel Repair Tool

This post introduces EaseUS Data Recovery Wizard to help you repair corrupted Excel files on Windows 10/8/7. And how to repair corrupted Microsoft Excel file online free? Use the top three tools to repair Excel file online free.

excel file corrupt

How to Fix A Corrupted Work Manually

In addition to the third-party software, Excel has a built-in feature to repair your workbook.

Solution 1. Fix Excel Workbook with Open and Repair Feature

Step 1. Open Excel, click the File tab on the top left side, and then choose Open.

Step 2. Choose the corrupted workbook from the stored location, click the arrow icon next to the Open button.

Step 3. Click Open and Repair from the drop-down menu.

repair corrupted excel

Step 4. In the Microsoft dialog, choose Repair to start repairing.

If the Repair fails to recover your data, you should repeat the previous three steps and choose Extra Data.

repair workbook excel

If the Open and Repair function can not repair your targeted data, try the next possible way to repair files from the TMP file.

Solution 2. Repair Excel Workbook via TMP File

Different from other backup option fail to update your newest data, Microsoft Excel holds the AutoSave function to automatically save temp files on your computer. So if your Excel workbook gets corrupted, you can follow the path to locate your backup and retrieve it.

Step 1. Go to temp files location on your computer and find the excel files with temp extension.

  • Storage path for Windows 8/10 uses: C:\Users\AppData\Local\Microsoft\Office\UnsavedFiles
  • Storage path for Windows 7 users: C:\Users\name\AppData\Roaming\Microsoft\Excel\ 

Step 2. Locate the temporary files that begin with "~" or "$" and end with".TMP".

Step 3. Change the.TMP extension as. XLS or XLSX, copy the files and save them to a safe location.

Bonus Tips: How to Avoid Excel Files from Corrupted

1. Check "Always create backup" for your Excel workbooks

Step 1. Open an excel file > Click File tab > Click Save As

Step 2. Under the save location, choose More options...

Step 3. In the Save As dialog window, click the arrow next to Tools and then click General Options.

Step 4. Check the Always create a backup box.

excel worknook create a backup

Step 5. Click OK > Save.

2. Set up automatically to create a recovery file in the schedule.

Step 1. Click File tab > Choose Options

Step 2. Go to Save category > Under the Save workbooks option, check Save AutoRecover information every minute. Enter the number by your preference.

autorecover excel

Was This Page Helpful?

Updated by Cedric

Cedric Grantham is one of the senior editors of EaseUS who lives and works in Chengdu, China. He mainly writes articles about data recovery tutorials on PC and Mac and how-to tips for partition management. He always keeps an eye on new releases and likes various electronic products.

Read full bio

Written by Roxanne

Roxanne is one of the main contributors to EaseUS and has created multiple posts on digital devices like PCs, Mobile phones, tablets, Mac, etc. She loves to share ideas with people of the same interest.

Read full bio

Product Reviews

TrustScore 4.7 | 323 reviews
  • EaseUS Data Recovery Wizard is a powerful system recovery software, designed to enable you to recover files you’ve deleted accidentally, potentially lost to malware or an entire hard drive partition.

    Read More
  • EaseUS Data Recovery Wizard is the best we've seen. It's far from perfect, partly because today's advanced disk technology makes data-recovery more difficult than it was with the simpler technology of the past.

    Read More
  • EaseUS Data Recovery Wizard Pro has a reputation as one of the best data recovery software programs on the market. It comes with a selection of advanced features, including partition recovery, formatted drive restoration, and corrupted file repair.

    Read More