Have you ever gotten a notification The file is corrupt and cannot be opened when opening an Excel file? Maybe a lot of people panic because the file is so important. But don't worry, because it is very easy to repair corrupted Excel data.

As we know, Microsoft Excel is often used to create tables that contain data. Not only the world of education, the business world also uses Excel to create sales and expense reports.

Not infrequently, damaged files cause the data in them to be lost. If so, eventually the user has to repeat the report from the beginning. However, before giving up, you should first consider how to repair a corrupted Excel file below.

How to Repair Corrupt Excel Data

The cause of corrupt Excel files or data is usually because the software is having an error. Also, in some cases there were errors while saving the document. However, Microsoft did not explain the exact cause.

So, to deal with a damaged or corrupted Excel file, there are several ways you can do it. If the first method doesn't work, you can try the second method and so on.

1. Open and Repair option on Corrupt Files

Actually, when a file is damaged, the program will automatically recover the file. However, sometimes the user is impatient because the data in it must be cleared immediately.

If you want to restore it yourself, you can try the first method, namely by using the repair option on damaged Excel files.

• The first step, please open Excel in a new worksheet
• Then click the File tab and select the Open menu, if in Excel version 2010 and above the Open menu is on the Office tab
• Find the file you want to repair, if you find it, click once on the file but don't open it
• Then click the down arrow near the Open button, select the Open and Repair option
• After the notification appears, the final step is to click Repair

You should be able to open the corrupted Excel data again. However, if there are still problems, you can select the Extract Data option to extract values ​​and formulas so that the data can be reprocessed.

2. Changing the Calculation Workbook

The next way to fix corrupted Excel data is by changing the Automatic option in the Calculation Workbook to Manual. You could say that this method is rarely known to people, therefore it is likely that this method will work.

• First open a new worksheet in Excel
• Click the File tab, then select Options at the bottom
• Then select Formulas and click the circle next to Manual then click OK
• After that, click the File tab again, click Open
• Finally, find and open the corrupted Excel file

3. Repair Corrupt Files in Recovery Tool Box Site

Damaged Excel files are sometimes more difficult to recover. Even though manual methods have been done, in fact, the corrupted file notification still appears. But don't worry, you can still repair corrupted Excel files online.

• The first step, please visit the website https://excel.recoverytoolbox.com/
• Select Repair Online
• Then click Select File and select the damaged Excel file
• Then fill in the email address and write the captcha code
• After that click the Next Step button
• Wait for the recovery process to complete
• Finally download the file

This method can recover corrupted Excel data for all versions of Excel, from 2007, 2010, 2013, 2016, to the latest versions. Some people find this method more effective, it's just that an internet connection is needed to do it.

If some of the methods above don't work either, you can use tools to recover corrupted data. One of the most popular tools is Kernel Data Recovery. Even though it's paid, there's a trial version that you can try for free.

 

In addition, you can use the Excel Viewer extension in Chrome as a last alternative. Although not for recovery, at least important data in corrupted Excel files can be saved.

By trying to fix corrupted Excel data in the review above, you don't need to repeat your previous work. However, you need to pay attention to always backing up files after completing the report so that this is no longer repeated.