Top 4 Ways to Repair Corrupted Excel Files
A corrupted Excel file is a mayhem message for any Excel user. After putting in all the hard work, if the file is corrupted, then it will create panic for the user. So, how to deal with these corrupted files? This article will provide you with some techniques to deal with corrupted files. Read the whole article to learn about repairing corrupted Excel files.
Table of contents
#1 Repair the Workbook Manually
Once the Excel file is corrupted and if you try to reopen it, Excel may start the file recovery mode by default. In addition, it may try to reopen the file and repair the workbook.
If you cannot open the Excel file because it is corrupted, we can repair the workbook through a manual process.
Follow the below steps to repair the corrupted excel workbook manually.
- We must first open one blank workbook. Then, click on the File tab.
- Now, we must click on the Open option and choose the Browse option.
- From this Browse window, we must locate the corrupted file.
- After that, click on the Open drop-down list in the same window and choose Open and Repair.
- Now, Excel shows the below message box.
We can Repair if we want to recover as much work as possible. So, to select this option, we need to click on the Repair option.
We can Extract Data if Excel previously failed to repair the workbook. So, to select this option, we need to click on the Extract Data option.
If Excel can repair the workbook successfully, we may get the below information message.
Now, in the newly opened workbook, we can see the status of the workbook as “Repaired.”
#2 Recover Data from Opened Workbook
If we cannot save the latest work from the workbook, we can recover the last saved version data from the corrupted workbook.
Then, we must click on the “File” tab and choose an “Open” option from another workbook. And select “Browse.”
Now, select the Excel workbook that needs to be repaired.
Then, click on “Yes” to reopen the workbook.
Now from this file, we can recover the data until the time auto-recovery lasts.
#3 Setting Calculation to Manual
Recover Data from Corrupted Workbook By Setting Calculation to Manual
If we cannot repair the corrupted Excel workbook, we can recover the data by setting the calculation mode to manual. Follow the below steps to get data from a corrupted workbook that it did not repair.
Step 1: We must firstopen a blank workbook..
Step 2: In the blank workbook, we must click on FILE >>> Options.
Step 3: In the “Excel Options” window, we need to go to “Formulas.” Under “Calculation options,” choose the workbook calculation to “Manual.“
Step 4: After this, click on “OK.” Now, go to “File” and open the corrupted Excel file to recover the data from the corrupted file.
#4 Create Backup Copy of Workbook Automatically
Having a backup copy of all the workbooks is gold.
We can instruct the Excel workbook to automatically create a backup copy of all the workbooks we work with. Follow the below steps to apply this setting change.
Step 1: We must first open any of the workbooks.
Step 2: Then, click on Save As in the excelSave As In The ExcelSave as is located in the worksheet's file tab. It can be accessed from the quick access toolbar or by pressing F12 and choosing "save as," or CTRL + S, which opens the save as dialogue box to save the file. button or press the F12 key.
Step 3: In the “Save As” window, we must click on the drop-down list of the “Tools” option and select “General Options.”
Step 4: This will open up the “General Options” window. In the below window, check the box “Always create backup.”
We can also choose the “Password to open” and “Password to modify” in the above window. So, if other than the user, anybody opens it, they must enter the password to open and modify the workbook.
Note: This setting applies only to this workbook. Any other workbooks remain the same.
Things to Remember
- If you have already struggled with corrupted files and cannot recover, you can use third-party software to repair your Excel workbook instantly.
- We must always create a backup copy of anticipated corrupting files.
- We must set the auto-recovery timing to have auto-recovery files at various stages of the workbook.
This article is a guide to Excel Repair. Here, we discuss how to repair corrupted Excel files in four ways: 1) Repair Manually, 2) Recover Data from Opened Workbook, 3) Setting Calculation to Manual, 4) Create Backup Copy. You can learn more about Excel from the following articles: –