How to Repair Corrupt Excel Workbook?

Summary: Corruption in an Excel workbook could lead to data loss. This blog outlines the possible reasons behind corrupted workbook and describes how to repair the workbook manually and using an Excel repair tool.

Is your Excel behaving differently, for instance, stops responding or freezes? Or have you encountered a warning or an error message indicating corruption in the Excel workbook?

Figure 1 - Corruption Warning in Excel: The corrupt workbook cannot be opened or repaired

Figure 2 - Excel File Corruption Message

In any of these situations, you won?t be able to open your Excel workbook.

TIP! If you?re unable to open an Excel workbook, it does not necessarily mean that the workbook is corrupt. Try a few workarounds to resolve the issue, like disabling the ?Protected View Settings?, disabling add-ins, or moving the workbook to another drive.

You will need to repair the corrupted Excel workbook to make it usable. Before discussing the repair methods, let?s first look at the possible reasons behind file corruption.

To jump to methods to repair the workbook, click here .

Possible Reasons behind Corrupted Excel Workbook

• Large size of a workbook: A workbook containing lots of information or objects like images, shaded cells, or other visual representations is prone to corruption.
• Unexpected system shutdown or power loss: If you haven?t saved your Excel file, abrupt system shutdown or power failure can corrupt the data and render the file inaccessible.
• Bad sectors on storage media: Accumulation of bad sectors on storage media on which Excel files are saved is another reason that may lead to Excel file corruption.

Other common reasons causing Excel file corruption are virus attack, network errors, etc.

Methods to Repair Corrupted Excel Workbook

Note: Repairing the corrupt workbook may result in data loss. And so, it?s recommended to back up the workbook before attempting to repair the file.

Method 1 ? Repair the Excel Workbook Manually

Use the Excel ?Open and Repair? feature to repair your corrupt workbook manually. Here?s how:

Step 1: In Excel, click the File tab and then click Open.

Step 2: Select the corrupt Excel file, click the arrow button next to the Open button and then select Open and Repair.

Figure 3 - Excel Open and Repair Feature

Step 3: In Microsoft Excel dialog box that opens, click Repair to begin repairing your corrupt workbook.

Figure 4 - Repair the Microsoft Excel File

Note: If the Excel repair process fails, repeat Steps 1 till 3 and click the ?Extract Data? button. This will help you extract values and formulas from the corrupted workbook.

Performing these steps will repair your Excel file. If the issue persists, skip to the next method.

Method 2 ? Use Excel File Repair Software

If the above method failed to fix corruption in the workbook, use Excel file repair software to repair your workbook quickly. This Excel repair tool is purpose-built to help users repair large-sized Excel files (.xlsx and .xls) in just a few clicks. Also, it helps recover all the data from the corrupted workbook while preserving the cell formatting and worksheet properties.

Steps to Repair Corrupt Excel File Using the Software

Step 1: Download, install, and open Stellar Repair for Excel software.

Free Download for windows ](https://tools.techidaily.com/stellardata-recovery/repaire-for-excel/ )

Step 2: Click Browse to select your corrupted .xlsx or .xls file. If you are not aware of the file location, click Search to locate and select the file.

Figure 5 - Select Corrupt Excel Workbook

Step 3: Once the file is selected, click Repair.

Step 4: A preview of recoverable workbook data gets displayed.

Figure 6 - Preview of Recoverable Excel Workbook Data

Note: You will need to activate the licensed version of Stellar Repair for Excel software for saving the repaired file. Once activated, proceed with the steps below to save the repaired file.

Step 5: Click Save File on the File menu. This will open a Save File dialog box with options to save the repaired .xlsx/.xls file at default or new location. After choosing the appropriate option, click OK.

Figure 7 - Save Repaired Excel File

The repaired file will get saved at the selected location.

Key Features of Stellar Repair for Excel Software

• Repairs severely corrupt Excel file and recovers pivots, pivot tables, conditional formatting rules, chart, chart sheets, etc.
• Can repair multiple Excel files in a batch simultaneously
• Can handle all types of Excel file corruption errors, like ?Excel found unreadable content in filename.xls?, ?Excel cannot open the file filename.xlsx?, etc.
• Supports repairing corrupt workbooks of Excel 2019, 2016, 2013, 2007, 2003, and lower versions.

End Note

If your Excel workbook has turned corrupt, try using the methods discussed in this blog to repair the workbook. Once it is repaired, you must follow preventive measures to avoid your Excel file from getting corrupt. Some of these measures are as follows:

• Reduce the size of your workbook by:

  • Removing unused data
  • Saving images at lower resolutions
  • Avoid saving pivot table cache

• Turn on the ?AutoRecover? and ?AutoSave? features in Excel

How to Fix Microsoft Excel Error Code 0x800A03EC?

Summary: You can encounter the error code 0x800A03EC in Excel due to different reasons. This post discusses the causes of the error and the workarounds and methods to fix it. If the “Microsoft Excel error 0x800A03EC” prevents you from accessing the Excel file data, use the Excel repair file tool mentioned in this post to restore the data with complete integrity.

The error code 0x800A03EC in MS Excel can occur while exporting or importing Excel sheets to or from another application. It can occur when trying to execute a macro. It usually appears when the Excel application fails to read the queries in the VBA code, especially when using the PasteSpecial method (Range.PasteSpecial method) to paste cell data from the clipboard into an Excel sheet. It can occur if the cell data format is not compatible with the target data.

Causes of MS Excel Error Code 0x800A03EC

The error code 0x800A03EC in Excel can occur in different scenarios. There could be several reasons associated with this error. Some of them are:

• Incompatible data formats.
• Trying to paste an extensive range of cells into a smaller range of cells.
• Add-ins are interrupting the code operation.
• Issue with the VBA code (incorrect or incomplete queries).
• Excel file is corrupted/damaged.
• Corrupted macros.
• Trying to export large-sized Excel file which is more than the Excel’s prescribed limit.
• Outdated Excel version.
• Incompatible cell formats on source and destination (when copying/pasting cell data).
• Missing cell range (forget to specify the range while using PasteSpecial method in the VBA code).
• Trying to save Excel file to incorrect directory.
• File path contains invalid characters.

Solutions to Fix MS Excel Error Code 0x800A03EC

The error 0x800A03EC can appear if your Excel file is incompatible with your Excel application version. You can run the compatibility checker  to review the compatibility issues in your Excel file. If this is not the issue, then follow the below methods.

Method 1: Review VBA Code

The exception from hresult 0x800a03ec excel can occur if you are trying to execute incorrect or incomplete queries in the Excel VBA code. It can also appear if the formulas do not contain the equal (=) symbol at the beginning. Verify the VBA code for any logical flaws, typo errors, syntax errors, or missing references.

Method 2: Check the Field Size

Excel has certain limits and specifications . If the Excel file’s data exceeds these designated size limits, you can get the MS Excel error code 0x800A03EC error. For example, this error occurs if you try to export a file with more rows than the limit of 65536 and columns than the limit of 256. Check and optimize the file size by minimizing complex formulas and other objects.

Method 3: Check Add-ins for Disabled Items

Sometimes, disabled items in Add-ins settings can prevent macros from functioning correctly. You can check and enable the disabled items in Add-ins using these steps:

• Navigate to File > Options.

• In Excel Options, click on the Add-ins option.
• Click the arrow corresponding to the Manage section.
• Select Disabled Items and click on the Go option.

• You will see a list of disabled items.
• Click on the disabled items and then click Enable.
• Restart Excel for the applied changes to take effect.

Method 4: Change Macro Settings

The error code 0x800A03EC can also occur if macros are disabled in the Macro Security settings. Follow these steps to change the macro settings in Excel:

• In MS Excel, go to File > Options > Trust Center.

• Under Trust Center, click on Macro Settings.

• Select Enable all macros and click OK.

Method 5: Check the OLE Objects

The Microsoft Excel error code 0x800A03EC can also appear if there is a connection disruption in the VBA. Such an issue can occur if there is an issue with Object Linking and Embedding (OLE) in an Excel workbook. The OLE objects are linked to external files. You can check and remove the unnecessary OLE objects from your Excel file to fix the issue.

Method 6: Check Methods in VBA

Excel can throw the “Exception from HRESULT: 0x800A03EC” error if you are trying to call an invalid method in a VBA code. Many users have reported this issue when trying to use ‘copy and paste’ feature using copy paste special method  (range.pastespecial) in Excel. Paste special is an advanced option in Excel to smooth the copy-and-paste task. While using this method, the exception can usually occur when Excel application detects an invalid or misaligned range or mismatch data type in the syntax. To fix this, check the syntax of the paste special method.

Method 7: Repair your Excel File

Corruption in Excel file can create inconsistencies in the macro and lead to the “Exception from HRESULT 0x800a03ec Excel” error. In such a case, you can try repairing the Excel file using Microsoft’s inbuilt utility – Open and Repair. To use this utility, follow these steps:

• In the Excel application, go to the File tab and then click Open.
• Click Browse to select the Excel file in which you are getting this exception error.
• The Open dialog box will appear. Click on the corrupted file.
• Click the arrow next to the Open button and then select Open and Repair.
• You will see a dialog box with three buttons – Repair, Extract Data, and Cancel.

• Click on the Repair button to recover as much of the data as possible.
• After repair, a message is displayed. Click Close.

The Open and Repair tool works in significant scenarios. If Open and Repair tool fails to resolve the issue, try an Excel repair tool recommended by experts and MVPs to repair the corrupted Excel file. Stellar Repair for Excel is one of the recommended Excel repair tools for fixing issues caused by corrupt Excel files. It provides more features than the Open and Repair utility. It can even repair severely corrupted Excel files. The tool supports all the versions of Microsoft Excel, including 2019. Download the software’s demo version to scan the corrupted file and see the preview of all the recoverable components of the file.

Conclusion

There are numerous reasons, like invalid method, incorrect range, data type mismatch, etc., that could lead to the common exception error 0X800A03EC in Excel. Try the troubleshooting methods mentioned above to fix the issue. You can also encounter the error due to corruption in the Excel file. In such a case, you can try the professional software – Stellar Repair for Excel – to repair the severely corrupted Excel file. The Excel repair software can fix all the corruption-related issues in Excel files (XLS/XLSX).

How to Resolve ‘Excel found unreadable content in filename.xlsx’ Error in MS Excel?

When opening an Excel spreadsheet in MS Office 2010/2007, you may get the following error message:

“Excel found unreadable content in ‘[filename].xlsx’. Do you want to recover the contents of this workbook? If you trust the source of this workbook, click Yes.”

On clicking ‘Yes’, you may face any of these scenarios:

Note: If you choose to click ‘No’, then open your MS Excel application and click file > Open. When the Open dialog box opens, browse and select the file showing the ‘Excel found unreadable content’ error and then choose ‘Open and Repair’ option. If this didn’t help, try using a third-party Excel repair tool to save time troubleshooting the issue and restoring the file with all its data intact.

Scenario 1: The following message may pop-up.

“Excel was able to open the file by repairing or removing the unreadable content. Excel recovered your formulas and cell values, but

some data may have been lost

. Click to view log file listing repairs errorxxx.xml.”

The message clearly states that your Excel file might open, but images may be lost and other such inconsistencies can crop up.

Scenario 2: The error is followed by another error message, like “The file is corrupt and cannot be opened“.

Watch our short video for a quick overview of the solutions to fix “Excel found unreadable content in filename.xlsx”

What Causes ‘Excel Unreadable Content’ Error?

You may encounter the ‘Excel file unreadable content’ error due to corruption of complete Excel file or corruption in certain areas (like Pivot Table, Formulas, Styles, or other objects) in the file. According to Microsoft, you may find it difficult to determine the root cause behind Excel file corruption. Corruption could occur in different scenarios, like power surge, a network glitch, copying and pasting corrupted data from another file, etc.

Also Read: How to recover data from corrupt or damaged Excel file 2010 & 2007?

Workarounds to Resolve the ‘Excel found unreadable content in filename.xls’ Error

There is no permanent solution to fix the ‘Excel found unreadable content’ error. But, following are some workarounds you can try to resolve the error.

Note: Before you try any of these workarounds, run Excel with administrator privileges and try opening the Excel file that is throwing the ‘unreadable content’ error. If this doesn’t fix the error, proceed with the workarounds below.

Workaround 1 – Try Opening the File in Excel 2003

Sometimes a problem in the current Excel version might prevent a file from opening. To resolve this error, try opening the problematic file in Excel 2003. If the file opens, save the data in a web page file format (.html) and then try opening the .html file in MS Excel 2010/2007. The detailed step-wise instructions are as follows:

• Open the .xls file in Excel 2003.
• When the file opens, click on File > Save.
• In the ‘Save As’ dialog box, choose Web Page (.html) as the ‘Save as type’ and then click ‘Save.’ Doing so will save everything from your .xls file, opened with 2003, in .html file format.
• Open the .html file in Excel 2010/2007. And then, save the file with .xlsx extension with a new name to avoid overwriting the original file.

Now, open the Excel 2010/2007 file and check if the error is fixed. If not, use the next workaround.

Workaround 2 – Make the Excel File ‘Read-only’

Try to open your ‘.xlsx’ file by making it ‘read-only’. Follow these steps:

• In Excel, click ‘File’ from the main menu.
• Select ‘Save’ for a new document or ‘Save As’ for a previously saved document in the screen that appears.

• From the ‘Save As’ dialog box, click Tools > General Options.

• Click on the ‘Read-only recommended’ checkbox to make the document read-only and then click ‘OK’.

Now open a new ‘.xlsx’ file and copy everything from the corrupt Excel file to this new file. Finally, save this file and try to open it again.

Workaround 3 – Move Excel File to a New Folder

Some users have reported that they could open their Excel file, following the ‘Excel unreadable content’ error, by simply moving the file to a different folder and saving it under a new name. You can also move the affected file to a new folder and try opening it. If this didn’t help resolve the error, follow the next workaround.

Workaround 4 – Install Visual Basic Component

At times, it is seen that installing the ‘Visual Basic’ component of MS Office 2010 resolves the ‘Excel found unreadable content 2010’ error. To do so, follow these steps:

• Navigate to Control Panel > Programs and select Microsoft Office 2010.
• Click ‘Change’ and then select ‘Add or Remove Programs’.
• Next, click the ‘plus’ sign provided next to Office Shared Features.
• Click ‘Visual Basic for Applications’. After that, right-click and choose ‘Run from My Computer’ and hit the ‘Continue’ button.
• Reboot your system when this process finishes.

Now check if the issue has been resolved or not.

What Next?

If none of the workarounds mentioned above works for you, use a professional Excel repair software, such as Stellar Repair for Excel. The software repairs corrupt MS Excel sheets without modifying their original content and formatting. In addition, it can repair single or multiple Excel (XLS/XLSX) files in a few simple steps.

Steps to Repair Corrupt Excel File using Stellar Repair for Excel Software

• Install and run Stellar Repair for Excel software.

• From the software main interface window, click ‘Browse’ to select the corrupt file. If you are not aware of the corrupt Excel file location, click on the ‘Search’ button.

• Click on the ‘Repair’ button to scan and repair the selected file.

• A preview window will open with recoverable Excel file data. Once satisfied with the preview result, click on the ‘Save File’ button on the ‘File’ menu to start the repair process.

• Select the destination to save the file.

• Click ‘OK’ when the ‘Repaired file saved successfully’ message appears.

 The repaired Excel file will get saved at the selected location.

Ways to Fix the “Failed to Parse the Corrupted Excel File” Error

Summary: While parsing an Excel file, you may experience the “Failed to parse the corrupted Excel file” error. It usually occurs if the Excel file is corrupt. This blog covers some easy fixes to fix this Excel error. It also mentions an advanced Excel repair tool that can help fix the issue by repairing the corrupted file.

You may encounter the “Failed to parse the corrupted Excel file” error when parsing (extracting or converting) the data in an Excel file. This error usually occurs if the Excel file is corrupted – either completely or partially (some of its objects, like formulas, macros, and values are corrupt). However, there are various other reasons that may lead to this Excel error. Let’s know the possible causes behind the “Failed to parse the corrupted Excel file” error and how to fix it.

Causes of the “Failed to parse the corrupted Excel file” Error

This error could occur due to any of the following causes:

• Damaged or corrupted macros
• Excel document is closed suddenly
• Issues with Excel application installation
• Virus or malware attack
• Hardware failure
• Bad sectors on the hard drive

Ways to Fix the “Failed to parse the corrupted Excel file” Error

Here are some possible ways to fix this error and recover the Excel file.

Method 1: Try to Save the File in a Different Format

Sometimes, the error can occur if the file format is not compatible with your Excel version. You can try saving the file to a different format. To do this, follow the below steps:

• Open the Excel file.
• Click on the File option and then select Save As.
• Click on Browse option and then click Save as Type.

• Select the desired Excel file format and click Save.

Method 2: Revert to the Previously Saved Version of the Excel File

You can try reverting to the previously saved version of the Excel file. Here’s how:

• Open your Excel application.
• Navigate to File > Info > Manage Workbook.

• Click Recover unsaved workbooks.

• Click on the Restore option you see at the top of the file.

Method 3: Set the Calculation Option to Manual

When the calculation mode is set to automatic, Excel automatically recalculates all the formulas in the file even if you make a minor change. It can take time to load the file and stop you from parsing data in your Excel file. You can change the calculation option to manual so that Excel only recalculates when you explicitly tell the application to do it. Here are the steps:

• Open your Excel application.
• Navigate to File and then click Options.
• In Excel Options, select Formulas.
• Under Workbook Calculation, select Manual and click OK.

Method 4: Use Open and Repair Utility

You can try repairing the corrupted Excel file with Excel’s inbuilt tool – Open and Repair . To use the tool, follow the steps cited below:

• In Excel, go to the File tab and then click Open.
• Click Browse to select the corrupted file.
• The Open dialog box will appear. Click on the corrupted file.
• Click on the arrow next to the Open button and then click Open and Repair.
• You will see a dialog box with three buttons Repair, Extract Data, and Cancel.

• Click on the Repair button to recover as much of your work as possible.
• After repair, a message will appear (as shown in the below figure).

• Click Close.

What If None of the Above Methods Works?

The above methods may fail to work if the Excel file is severely damaged. In such a case, we recommend using an efficient Excel repair tool , such as Stellar Repair for Excel. It can quickly repair corrupted Excel (.XLS/.XLSX) files. It can recover all the objects from the file, including charts, tables, formulas, etc. You can download the free trial version of the tool to preview the recoverable data.

Conclusion

Above, we have discussed some tried and tested methods to fix the “Failed to parse the corrupted Excel file” error. If the Excel file is severely damaged or corrupted, you can try repairing it using a third-party Excel repair software, like Stellar Repair for Excel . It can repair multiple Excel files without affecting the original formatting. The tool is compatible with all Excel versions.

Solved - The File is Corrupted and Cannot be Opened - Excel

Summary: Unable to open Excel file due to the error ‘The file is corrupted and cannot be opened’? Read this blog to find more details about the error, possible reasons behind it, and solutions to fix the error. In addition, the blog mentions about Stellar Repair for Excel software that can help fix the Excel error in a few clicks. Download the software now and see free preview of the file.

About the Error

Microsoft Excel is a widely used spreadsheet application that comes bundled with MS Office. Users tend to update the application with new security patches and features. Sometimes these updates can cause problems, and result in “The file is corrupted and cannot be opened” error.

Figure 1 – Excel File Corrupted Error Message

Other Possible Reasons behind ‘The File is Corrupt and Cannot Be Opened’ Excel Error

• Opening an older Excel version file in a newer version of Excel. For instance, opening Excel 2013, 2010, or earlier versions in Excel 2016.
• When attempting to open a Microsoft Office (Excel) email attachment in Microsoft Outlook 2010, MS Office 2010 reports a problem with the file preventing it from opening.

How to Fix the ‘Excel File is Corrupt and Cannot Be Opened’ Error?

Here are a few possible solutions that you can try to fix the ‘Excel file is corrupt and cannot be opened’ issue and open your Excel file.

Solution 1: Changing Component Services Settings

Solution 2: Changing the Protected View Settings

Solution 3: Repair Excel Files using Excel Repair Software

Solution 1: Changing Component Services Settings

[Caution] Changing Component Services settings requires making changes to the registry, and any mistake can harm your computer.

Follow these steps to change ‘Component Services’ settings:

• Click ‘Start’ or ‘Win+R’ and type ‘dcomcnfg’ and press ‘Enter’.

• In the navigation pane, expand the ‘Component Services’, and then expand ‘Computers’.

---

Figure 2 – Component Services Settings

• Next, right-click on ‘My Computer’, and then click ‘Properties’.

When the ‘My Computer Properties’ dialog box appears, click on the ‘Default Properties’ tab and then set the following values:

• Default Authentication Level: Connect
• Default Impersonation Level: Identify

Figure 3 – Illustrates My Computer Properties

• Click ‘OK’ to change ‘Default Properties’

Solution 2: Changing the Protected View Settings

[Caution] Disabling the ‘Protected View’ can put your system at high risk. Viruses attached to the Excel files can attack and infect your system. Be careful before using this option.

Excel 2010 file cannot open due to the ‘Protected View’ setting in Microsoft Outlook 2010. And so, changing the setting may help fix the error. For this, perform these steps:

• Open MS Excel 2010, go to the ‘File’ menu and click ‘Options’.

Figure 4 – Options

• When the ‘Excel Options’ window opens, click on ‘Trust Center’ and then on ‘Trust Center Settings’.

Figure 5 – Open Trust Center Settings

• Next, choose ‘Protected View’ and uncheck all the options including ‘Enable Protected View for Outlook attachments’ if you use Outlook for email.

Figure 6 – Uncheck Protected View Settings

• Click ‘OK’. Restart the application and try opening the Excel file again.

If none of the above solutions works for you, your Excel file is likely severely corrupt. To repair corrupt Excel files, you need to use advanced options like Stellar Repair for Excel tool. It repairs corrupt and damaged Excel files and helps in retrieving lost data.

Solution 3: Use Excel File Repair Tool

Considering the risks associated with the above solutions, it’s better to use an Excel repair tool to repair single or multiple corrupt Excel files at once. The process is simple, and even a novice can use the Excel file repair tool to repair Excel files with the help of the following steps:

• Download Stellar Repair for Excel and install it.

• Launch the tool. In the tool’s main interface, click ‘Browse’ to select the file. If you don’t know the file location use the ‘Search’ option.

Figure 7 – Illustrates Selecting Corrupt Excel File in Stellar Repair for Excel

• Select the file, and then click on Repair.

Figure 8 – Illustrates Initiating Excel File Repair in Stellar Repair for Excel

• The software scans and lists the Excel file in the left pane. Click on the file to preview its recoverable objects in the right pane.

Figure 9 – Illustrates Preview of Recoverable Excel File Objects

• Save the repaired file at either the default location or a user-specified location.

Figure 10 – Illustrates Saving Repaired Excel File in Stellar Repair for Excel

• Click ‘OK’ to save the repaired Excel file. After the repair process is completed, browse to the location and open it with MS Excel 2010 or any other version.

Figure 11 – Illustrates Saving Complete Message in Stellar Repair for Excel

You will be able to access your Excel file from the selected location.

Conclusion

You can use the first two possible solutions to fix the “The file is corrupted and cannot be opened” error. If you can access the file, save its data and restore the default settings. However, if the file is corrupt and the data retrieved using the first two solutions is inconsistent or incomplete, use Stellar Repair for Excel. This tool can help you recover Tables, Charts, Chart Sheets, cell comments, Images, and Formulas while preserving the worksheet properties and cell formatting. You can also preview the file and verify the data inside the file before saving it.

Simple ways to Open Corrupt Excel file Without any Backup

Summary: The blog describes simple ways to open corrupt Excel file without any backup. It explains some manual workarounds that you can try to open the file. Also, it mentions about an Excel file repair tool that can quickly fix the corrupt file and recover data from it.

Do you have an Excel file that does not open because of corruption issue? And every time you try to open it, an error message ‘the file is corrupt and cannot be opened’ pops-up?

Excel File Corruption Message

Also, you don’t have a healthy backup of the Excel file to restore the data? If so, you can try repairing the corrupt file by using a few simple yet effective manual workarounds mentioned below.

How to Open a Corrupt Excel File without Backup?

Following are some manual methods that can help you open a corrupt Excel file:

Method 1: Repair Corrupt Excel File

When attempting to open a corrupt file, Excel automatically starts ‘File Recovery’ mode to repair the file. But, if the recovery mode doesn’t start, try Microsoft Excel’s built-in ‘Open and Repair’ feature to manually repair the file.

To use this feature, perform the following steps:

Step 1: Open a Blank workbook in Excel, and then click File > Open.

Step 2: In the Open window, browse and select the corrupt file.

Step 3: Click the arrow that is beside the Open tab, and select Open and Repair.

Open and Repair Option

Step 4: Implement one of the following:

• Click the Repair button. (This is to recover as much data as possible.)
• Click the Extract Data button. (This is to recover values and formulas from the Excel file if the repair process fails to recover the entire data.)

Excel Built-in Repair Options

If using Open and Repair does not work , move to the next method.

Method 2: Disable the Protected View Feature

Some Excel users have reported that turning off the ‘protected view’ feature in Excel helped them open the corrupt file. You can also try to disable this feature and open the file. To do so, follow these steps:

Step 1: Open a blank Excel file, click on File > Options.

Step 2: In the Excel Options window, select Trust Center, and then click Trust Center Settings.

Excel Trust Center Settings

Step 3: Click OK.

Now check if you can open the corrupt file. If not, try implementing the next method.

Method 3: Look For Automatically Recovered Excel File

If you have Excel’s AutoRecover feature enabled, you’ll have access to a copy of the Excel file corrupted or lost due to application crash, power outage, or accidental deletion.

The ‘AutoRecover’ feature saves Excel worksheets at a temporary location after a certain time interval. It saves the worksheets automatically and is turned on by default to reduce the chance of data loss.

Check if you can recover corrupted Excel file by following these steps:

Step 1: In Excel, open a Blank workbook.

Step 2: Go to File and click Options.

Figure 5 – Excel Options

Step 3: In the Excel Options dialog box, click Save, and then copy the ‘AutoRecover file location’.

Excel Options Window

Step 4: Open File Explorer window and paste the copied AutoRecover file location, and press Enter.

Step 5: A list of saved Excel files will be displayed. Choose the file you want to recover.

TIP: Use Excel’s AutoBackup feature to reduce chances of data loss, by saving a previous version of your spreadsheet automatically.

Use an Excel File Repair Software

If the above manual methods fail, repair the corrupt Excel file by using a third-party software, such as Stellar Repair for Excel**.** The software helps repair Excel (XLS and XLSX) files easily and effectively.

Read this: How to repair corrupt Excel file using Stellar Repair for Excel?

Some key features of Excel Repair software are as follows:

• Fixes all errors in the MS Excel file.
• Repairs multiple damaged Excel files in a go.
• Recovers chart, chart sheet, table, cell comment, image, formula, and sort & filter.
• Preserves properties and cell formatting of Excel worksheets.
• Previews recoverable Excel file data before saving.
• Recovers all data components from the corrupt files and saves them in a new blank Excel file.
• Compatible with Excel 2019, 2016, 2013, 2010, 2007, and lower versions.

Conclusion

You can try the workarounds discussed in the blog to open a corrupt Excel file without a backup. Disabling the protected view feature can help you open the file. If the issue persists then try repairing the corrupted Excel file using the Open and Repair utility. Although, it may not be able to fix a severely corrupted workbook. In such a case you can use Stellar Repair for Excel . It is an advanced tool that can help you repair a corrupted Excel file with 100% integrity.

How to Fix the #Value! Error in Excel?

Summary: #Value! is a common error that occurs when using formulas in Excel. It can be due to an issue with the cells you are referencing or use of formulas in the wrong type or format. This blog will discuss some cases when this error may occur and the solutions to fix the issue. You’ll also find about an Excel repair software that can help fix the error if it has occurred due to corruption in Excel file.

You may experience the #Value! error in Excel when trying to enter invalid data type into the formulas. Sometimes, it appears when a value is not the expected type or when dates are given a text value. This Excel error may occur due to several reasons. However, the exact cause of this error is difficult to find. Below, we will be discussing some cases where you may get this error and the solutions to resolve the issues.

Case 1: Wrong Argument Data Type in Formulas

Sometimes, Excel throws the “#Value!” error if it recognizes incompatible arguments in the formulas.

For example: The Date function in the sheet expects only numerical values as arguments. In the below image you can see that when the formula’s string value is used in the month (January), it resulted in the #VALUE! error.

Solution

To fix the issue,

• Double-click the formula to verify the type of arguments.

• Correct the argument in the cell (B2).

The formula will work as expected.

Case 2: Using the Basic Subtraction Formula

Users often experience the #Value! error, when using the basic subtraction formula in Excel.

Solution

Check the formula and the type of values in the cell. If these are correct and the error persists, then follow these steps:

• Go to the Start button on Windows, type Control Panel, and double-click on it.
• Click Clock and Region > Region.

• On the Format tab, click Additional Settings.

• In the Customized Format window, search for List Separator.

• Check if the List Separator is set to minus (-). Change it to comma (,).

• Click OK.
• Now, open the Excel file and again try to use the formula.

Case 3: Wrong Text Value

The #Value! error can also occur due to the formula’s wrong value.

For example: If you are using the formula to add values in cells and Excel recognizes the unexpected text value, you may get a #Value error.

Solution

To fix the issue, you can correct the value or use the SUM function. It is recommended to use functions instead of operations to reduce the errors. In Excel, the formulas with math operators may not able to calculate the text in the cells. The SUM function automatically ignores the text value(er), calculates everything as numbers, and displays the result without the #Value! error.

Case 4: Blank Space in Cells

You may get the #Value! error if your formula refers to other cells with space or hidden space. Sometimes, spaces that make a cell display blank but actually they are not blank.

Solution

You can either delete the space or replace the blank space. Here’s how:

1. Delete the Blank Space

First, check if a cell is blank or not. To do this,

• Select the cell that looks blank.
• Press F2.

The blank cell won’t show space.

Then, press the Backspace key to delete the space. It will fix the error.

2. Replace Blank Space

You can also use the “Find and Select” option to replace the blank space in Excel. Here are the steps:

• Open the Excel file that shows #Value! error.
• On the Home tab, click Find & Select > Replace.

• In the Find what field, type a single space and delete everything in the “Replace with” field.

• Click Replace All > OK.

Case 4: Problem with Network Connection

Many users have reported experiencing errors when using Excel online due to problems with the network connection.

Solution

Check your Internet connection and see if it is working properly.  

Case 5: Wrong Formula Format

If you enter the wrong formula with a missing parenthesis or comma, then Excel can throw the #Value! error. The error can also occur if the application finds a special character within a cell.

Solution

Correct the formula and use the ISTEXT function to find the cells with issues.  

Case 6: Corruption in the Excel File

If none of the above works, then it indicates the Excel file is corrupt. The formulas in the Excel file do not work due to corruption.

Solution

You can use the Open and Repair utility in Excel if you are getting the error due to corruption in Excel file. In case the utility fails or the Excel file is severely corrupt, you can use a third-party Excel repair software, such as Stellar Repair for Excel. It is a powerful tool to repair corrupted or damaged Excel files and recover all its data, with 100% integrity. The tool supports Excel 2019, 2016, and older versions.

Closure

There are several reasons that can trigger Excel to throw the #Value! error. It can occur if there is an incorrect argument data type in formulas or blank space, text, or special characters within a cell. This blog discussed the possible scenarios when this error occurs. You can apply the solutions mentioned above to fix the error. If the #Value! error occurs due to corruption in the Excel file, then you can use Stellar Repair for Excel . It is a reliable tool that helps in fixing corruption-related errors in Excel.