Summary : This Knowledge Base aims to help you fix or repair corrupt Excel files including Excel 2019, 2016, 2013, 2010 and 2007. Besides, it discusses the reasons and causes for corruption of Excel spreadsheets.
Stellar Data Recovery offers a complete range of data recovery options arising due to different data loss scenarios. You can choose the most
preferable data recovery option as per your need.
If you want to jump directly to the fixes, click here.
Ms Excel files are amongst the most commonly used office documents. Excel file Corruption of such documents means loss of important data which might have a severe impact on your business.
Ms Excel files that include Excel 2019, 2016, 2013, 2010, 2007, etc. are digital in nature, they comprise several components that contain different pieces of information. These pieces of information, known as metadata, help Excel files to function properly.
Signs of a corrupt Excel workbook
Reasons for Corruption of Excel files
File corruption is the result of broken metadata which happens because of the following reasons:
[NOTE: If you encounter a problem opening the Excel files after upgrading to the latest Windows Operating System (OS) and Office program, try updating your Office as well as Windows OS to latest patches provided on the Microsoft website. Microsoft frequently releases Office and Windows OS patches to correct known errors. You may be able to open the corrupt workbook after installing the update.]
As already discussed, if you’re unable to open an excel file, it’s probably corrupt. But this is NOT always true. You may be unable to open an Excel file and get the errors that indicate file corruption even if the file isn’t actually corrupt. The methods mentioned here would consider both the scenarios. While we troubleshoot to fix the issue, we’ll get to know if the file is actually corrupt or not and take action accordingly.
If an Excel sheet gets corrupt while you’re working on it, but before you save the changes, revert to the last saved version.
[Note: If the AutoRecover option is turned on, you can automatically save versions of your file while you’re working on it. How you recover something depends on when you saved it.]
If you have saved the file, follow these steps:
Step 1. Open the file you were working on.
Step 2. Go to File > Info.
Step 3. Under Manage Workbook or Manage Presentation, select the file labeled -- “when I closed without saving”.
Step 4. In the bar at the top of the file, select Restore to overwrite any previously saved versions.
If you haven’t saved the file, follow the steps below:
Step 1. Go to File > Info > Manage Document > Recover Unsaved Workbooks in Excel, or Recover Unsaved Presentations in PowerPoint.
Step 2. Select the file, and then select Open.
Step 3. In the bar at the top of the file, select Save As to save the file.
[CAUTION: Disabling "Protected View" may harm your computer as it exposes your computer to security threats. If you’re able to access the file after disabling “Protected View”, save it with a new name and enable “Protected View" again. ]
Step 1. Create and open a new excel file and go to File > Options.
Step 2. Click Trust Center > Trust Center Settings.
Step 3. Click Protected View and unselect all the boxes. Click OK.
Step 4. Open the affected excel file.
If this doesn’t fix the Excel file issue, move to the next method.
[CAUTION: Modifying the “Component Services” settings will make some registry changes. Make sure that you don’t make a mistake while following the steps to change these settings. ]
Step 1. Press Start at the bottom-left corner of your system.
Step 2. Type doom
Step 3. Right-click Component Services Application and select Run as Administrator.
Step 4. Expand Component Services > Computers > My Computer.
Step 5. Right-click My Computer. Select Properties.
Step 6. Click Default Properties. Under Default Authentication Level, select Connect. Under Default Impersonation Level, select Identity.
Step 7. Press Apply and then press OK.
It’s possible that the current version of your MS Office Application isn’t supporting the file extension of your excel file. Change the file extension to .xls. Follow the steps below:
Step 1. Copy the affected excel file on the root of a volume such as ‘F’ volume on your computer.
Step 2. Run Command prompt as an Administrator.
Step 3. Enter the address of the volume where you copied the affected excel file. For instance, type F: and hit Enter.
Step 4. Run the command:
Ren Book10.xlsx NewExt.xls
Where, Book10.xlsx is the affected excel file with previous extension, and NewExt.xls is the same affected file with .xls extension.
Step 5. Try to open the file now and see if the issue is resolved.
If the issue is not resolved yet, follow the next method.
At times, you may get an error message which indicates that the file is corrupt, but the actual problem could be the conflicting COM Add-Ins. Follow the steps below to disable the COM Add-Ins.
Step 1. Create and open a new excel file and go to File > Options.
Step 2. Click Add-Ins. Select COM Add-Ins under Manage. Click Go.
Step 3. Unselect/Uncheck all the checkboxes and click “Ok”
Step 4. Try to open the affected excel file
If doing this fixes the issue, one or more Add-In was the cause behind it.
Step 5.Enable one of the Add-Ins and restart the affected excel file.
Repeat this process for the remaining Add-Ins. If the issue resurfaces after enabling a particular Add-In, that particular Add-In needs to be kept disabled to fix the issue.
If none of the above methods helps in fixing the issue, your excel 2019, 2016, 2013, 2010 file is corrupt. Follow the next methods to repair and recover the corrupt excel file.
Step 1. Create and open a new excel file and go to File > Open.
Step 2. Browse the corrupt excel file
Step 3. Select the corrupt excel file and click Open from the dropdown menu. Select Open and Repair.
Step 4. Click Repair
Step 5. If Repair doesn’t recover the corrupt excel file, click Extract Data.
[CAUTION: Using Extract Data to repair and recover the excel file keeps just the data (formulas and values) of the file and doesn’t retain the formatting.]
If Open and Repair utility doesn’t work, go for an Excel Repair Software.
There are plenty of excel repair softwares available in the market that can be used to recover corrupt excel files. But how do you choose the one that’s most reliable? Here’s a guideline that you can follow:
How to choose the best software to repair corrupt excel files?
Stellar Repair for Excel is one such trusted software to repair corrupt excel files. Go through the features of this software if you wish to choose this one.
*Free trial version of this software allows you to “Preview” the repaired excel files. This helps you to ascertain the effectiveness of the software. Once you’re confident, you can activate the software and save the repaired excel files.
Excel files may become corrupt due to malware infection, sudden system shutdown, or any other reason. But considering the increasing dependency on Excel files for business purposes, this may not be a good news. It is advisable to work on Microsoft Excel with automatic backup turned on. That ensures that if your workbook is deleted accidentally or gets corrupted, you can recover it from the back up. But if you are still struggling with a corrupt Excel sheet, this post has outlined a few methods that can help in retrieving your files. And if the methods don't work, you can rely on Stellar Repair for Excel software to retrieve damaged/corrupt files.
Stellar offers the widest range of DIY data recovery software for all operating systems/ file systems. The software recovers your lost, deleted or formatted data from all internal & external storage media.
Remote/Online Data Recovery
Get back your data online now. We provide online data recovery service In some cases where data loss reason is logical And your storage media is detecting in your System.
WE ARE OPERATIONAL
Amid COVID-19 pandemic, Stellar® Data Recovery lab and recovery services are fully operational to serve your needs. You can avail our Online Remote Data Recovery Service. Stellar® encourages you to avail our free courier pick up service to submit your damaged media devices for data recovery