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
- 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
