4 Ways to extract data from corrupt Excel file

Summary: Excel files can become corrupt due to numerous reasons. This blog will discuss the reasons behind the corrupted Excel files. Sometimes the file becomes inaccessible. This post includes four ways to extract data from a corrupt Excel file. It also mentioned Stellar Repair for Excel to repair severely corrupted files. The tool helps you recover data from damaged Excel files with complete integrity.

Imagine the frustration of an employee if an Excel workbook he took hours to complete became corrupted for some reason threatening to erase all the data saved in it. Not just that, a corrupted Excel workbook can wreak havoc for the organization too since it poses a risk of permanently deleting critical business information like work records or employee trackers.

Unless a backup of all important Excel files exists, recovering data lost due to damage/corruption to them is next to impossible. However, we’ve conducted some research and found some pretty neat hacks to help you extract data from corrupt excel files without much hassle.

Primary reasons triggering Excel file corruption

As we always point out, to solve a problem for good, getting to its root is imperative. Here are the main reasons that cause Excel file corruption. Knowing these reasons can help you keep Excel corruption at bay for a considerably long time.

• Abrupt system shutdown when you’re editing an Excel sheet
• Bugs / Defects in your Excel application or installation
• Hardware failures like bad sectors on the hard drive where Excel sheets are saved
• Virus Infection / Malware Attack
• Excessive data storage within a single Excel file
• Faulty Excel Macros and CSE Formulas

Depending upon the extent of damage, there can be several ways to perform corrupt Excel file repair.

How to repair corrupt Excel files?

There are a couple of manual methods that can help you repair corrupt Excel files .

1. If the damaged Excel sheet can be opened, immediately save its copy; thereafter:
   • Open it with a later version of Excel and save it as a new workbook.
   • If this doesn’t work, open it in Excel’s latest version and save the workbook in HTML or HTM format.
   • Once this is done, reopen the HTML file and save again in XLS format.
   • Lastly, open the file and try saving it in SLK format (symbolic link)

Note: It is important to note that saving an Excel workbook in HTML format causes loss of features like custom views, scenarios, unused styles or number formats, natural language formulas, data consolidation settings, custom function categories, etc. In SYLK format only the active worksheet is saved so if using this method, you’ll need to repeat these steps for each worksheet.

2. Use Excel’s inbuilt Repair function as follows:
   • Launch Microsoft Excel and go to Office button -> Open
   • In the Open dialog box, select the damaged Excel file
   • On the bottom-right corner of the Open dialog box, you will find a drop-down next to Open Click on it and select Open and Repair
   • This will launch the inbuilt Repair module of Excel and you’ll see a dialog box asking you to select an option from Repair or Extract Data
   • Click on Repair to initiate the repair process.
   • If this doesn’t work, repeat steps 1-4, and when Excel asks you to select an option, select Extract Data from corrupt excel file. Thereafter, follow the instruction Excel shows and you should be able to retrieve your data, but you may end up losing some formulas.
3. If you cannot open the Excel, download Spreadsheet viewer from the Microsoft website and open the file using this program. Thereafter copy all data into a new Excel.

Note: This method will cause much of your formatting, formulas, and more to be lost.

4. You can download Open Office from its official website OpenOffice.org and try opening the Excel in it. The two programs are very similar so all data should automatically align in the correct place and with the correct formatting.

Note: With this method, VBA code cannot be recovered due to incompatibility between OpenOffice.org and Excel.

Full-proof method for corrupt Excel file repair

If you find the above methods confusing, or you wish to perform Excel file repair without having to face any data and formula loss, or you cannot achieve the desired results with any of these methods, stop wasting any more time with methods that will only frustrate you more. Instead, download the sure-shot solution for dealing with severe Excel corruption –Stellar Repair for Excel  and relax!

Stellar Repair for Excel is the best choice for repairing corrupt or damaged Excel (.XLS/.XLSX) files and restoring everything to a new blank Excel file. This competent software can skillfully repair single as well as multiple XLS/XLSX files while preserving worksheet properties and cell formatting. If you have this product by your side, you don’t need to worry about Excel corruption errors ever again.

To Conclude

Instead of giving up on corrupted Excel sheets, try repairing them with the simple tricks we’ve described. And if they don’t work, keep calm and turn to Stellar Repair for Excel.

How to fix “damage to the file was so extensive that repairs were not possible” Excel error?

Summary: Unable to resolve “damage to the file was so extensive that repair was not possible” error in Excel? Read this post to discover more details about the error, possible causes, and how to rectify the error. To save time & efforts, you can also try an Excel file repair software to resolve the “damage to the file…” error in a few clicks.

When opening a workbook in Microsoft Excel 2003 or later, you may encounter an error message,

“Damage to the file was so extensive that repairs were not possible. Excel attempted to recover your formulas and values, but some data may have been lost or corrupted.”

The error message may also occur while exporting an Excel file. Let’s find out what causes this error and what we can do to fix it.

Reasons Behind “Damage to the File Was So Extensive That Repairs Were Not Possible” Error

Your Excel file may be corrupt, oversized, virus-afflicted, etc., which can trigger this error and make the repair impossible. Below are some common reasons.

• Large or oversized excel files hindering export
• Data restore errors
• Field length of a cell is more than 256 characters
• Software conflicts, viruses, network failure
• Unable to open files in upgraded versions
• Errors on output exceeding 64000 rows
• Limited system resources (such as RAM, internal memory)

In a nutshell, the error generally happens if Excel discovers unreadable content, which may also interrupt file saving in Excel.

How to Resolve “Damage to the File Was So Extensive That Repairs Were Not Possible” Error?

Here are a few methods you can follow to fix or resolve the Excel repair error.  

Method 1: Perform Basic Troubleshooting

When opening a corrupt workbook, Microsoft Excel automatically initiates the file recovery mode to repair the corrupt file. However, if it fails to perform automatic recovery, then follow these basic troubleshooting steps:

• This error mainly happens when you try to open the Excel file in an upgraded version.  Try to open the file in an older version of Excel. You might be able to open it.
• Try saving the file with a different file name.
• Use a different file extension to save the file.
• You can save the Excel file as HTML and then open it. However, an HTML file might not save conditional formatting.
• Close other opened applications on the system which may be causing the error.
• Select less data for export at once.
• Delete worksheets if copied from another document; for instance, delete any file or screenshots you have imported.
• Open the file on another system.

If the error persists, then use the manual method to repair a workbook using the below steps:

• Go to the “File” tab.

• Select Open and select the damaged spreadsheet from the Recent Workbooks section on the right, if listed. However, if you cannot find the file in the Recent Workbooks section, click on “Browse” and choose the corrupted workbook.

• Click the drop-down arrow on the Open tab and select Open and Repair.

Method 2: Check if exporting a Heavy File is Causing Resource Limitations in Excel

Sometimes, when you try to export an Excel sheet carrying a huge database, you may face memory errors in older Excel versions like Excel 2003. Here, you’ll have to decrease the amount of data as Excel 2003 does not permit exporting extensive data beyond a limit. However, modern versions such as Excel 2007, 2010 & 2016 allow exporting a large amount of data and utilize more RAM than the older versions.

Following are some other workarounds:

• Use a lesser number of query presentation fields to re-generate the query. Then, again re-enter those fields.
• Decrease the multi-line string field data text up to 8000 characters.

Method 3: Copy Macros and Data to Another Workbook (Empty) in an Advanced Excel version

If the issue is occurring due to version incompatibility, i.e., if the file opens easily in the older version but shows errors in the new version. You can:

Use the older version to open the file or copy the data or macros in an empty workbook of the new version of Excel.  

Copying the Macros in the Workstation

In Microsoft Excel, you can use the Visual Basic Editor to open the workbook with macro on another workbook by copying the macro. Both VBA tools and Macros appear in the Developer section of the excel file. This option is disabled by default. So first, you need to enable it.

Follow the instructions to enable it:

• Open Excel and go to File > Options.

• Click “**Customize Ribbon.**”

• Look at the right side of the pane and ensure the Developer tab is checked.

• Click OK.

Once you have enabled the Developer tab, follow the steps to copy the macro from one workbook to another:

• First, open both the workbooks- the workbook containing the macro and the workbook in which you need to copy the macros.
• Locate the Developer tab.

• Select Visual Basic to display the “Visual Basic Editor.”

  

• Go to the View menu in the Visual Basic Editor.

• Select Project Explorer.

• In the Project Explorer window, drag the module you need to copy to the destination workbook. For example:

Module 1 has been copied from Book2.xlsm to Book1.xlsm

Method 4- Restore the backup file

The workbook backup helps to open the corrupted or mistakenly deleted file. Sometimes, the issue can be fixed using the Recover Unsaved Workbook option in Excel. Here’s the list of steps to recover the files in Microsoft Excel:

• Go to the File tab on Excel.

• Click Open.

• Search on the top-left of the screen to click Recent Workbooks as below:

• Next, scroll down to the bottom.
• Click the “Recover unsaved workbooks” button.

• Scroll and find the lost file.
• Now double-click on the file to open.

Conclusion

“Damage to the file was so extensive that repairs were not possible” error can be fixed with the above troubleshooting methods or by using a third-party Excel repair tool, like Stellar Repair for Excel . Although There are no standard resolutions to fix the excel error as they may vary with different scenarios. In some cases, the manual methods might be time-consuming or fail to fix the error or recover the excel file. Hence, using an excel file repair tool may be the best option! It extracts data from the corrupted file and saves it to a new Excel workbook, which you can open and edit.

How to Fix ‘Sharing Violation Error’ when Saving Excel?

Summary: You may encounter the sharing violation error in Excel when you repeatedly save changes in a workbook. The error can occur due to different reasons. In this blog, we will discuss the possible reasons behind this sharing violation error and some effective solutions to fix it. If the issue has occurred due to corruption in Excel file, you can try the advanced Excel repair tool mentioned in the post to repair the corrupted file.

It is not uncommon to encounter errors while working with Excel application. One common error that Excel users face is the sharing violation error that occurs while saving an Excel spreadsheet. The complete error message says, “Your changes could not be saved to file because of a sharing violation.” When this error occurs, users won’t be able to save the changes in the file. So, it is important to fix this issue as soon as possible. But before fixing the error, let’s find out the causes behind this error.

Causes of Excel Sharing Violation Error

This error may pop up due to the below reasons:

• The file you are trying to save is corrupted.
• The Excel file is not in the trusted location.
• Sharing Wizard is disabled.
• You do not have permission to modify the Excel file.
• The Excel file is not permitted to get indexed.

Methods to Fix the Sharing Violation Error in Excel

You can move the affected Excel file to a new folder and save it with a different name. Then, see if it fixes the error. If it doesn’t help, you can try the below methods.

Method 1: Check and Change the Excel File Properties

You can get the sharing violation error in Excel if the file attribute options, such as “File is ready for archiving” and “Allow this file to have contents indexed in addition to file properties” are disabled. You can check the File Properties and enable these options to fix the issue. Here are the steps:

• Right-click on any Excel file and select Properties.

• In the Properties window, click on the Advanced option.

• In the Advanced Attributes window, select the below options under File attributes:
• File is ready for archiving.
• Allow this file to have contents indexed in addition to file properties.

• Click OK.

Note: If these options are already selected, then unselect and re-select them.

Method 2: Enable Sharing Wizard Option

The error “Your changes could not be saved to file because of a sharing violation” can also occur if the sharing wizard option is disabled on your system. You can check and enable the sharing wizard option using these steps:

• Go to your system’s Documents folder.
• Click View > Options > Change folders and search options.

• In the Folder Options window, click View.

• Under the View section, search for the “Use Sharing Wizard” option in the Advanced Settings.

• If the Use Sharing Wizard option is unselected, select it and then click OK.

Method 3: Move the Excel File to a Trusted Location

You can encounter the sharing violation error if the file you are trying to save is not in the trusted location. You can try moving the file to a trusted location by following these steps:

• In Excel, go to File and then click Options.
• Click Trust Center and then click Trust Center Settings.

• In the Trust Center window, click Trusted Locations and then click Add new location.

• In the Add new location window, select Browse to locate and choose the folder, and then click OK.

Method 4: Open Excel in Safe Mode

Incompatible add-ins can create issues in the Excel file. To check if the sharing violation issue has occurred due to add-ins, open Excel in safe mode. To do so, follow these steps:

• Open the Run window using Windows + R.

• Type excel /safe and click on OK.
• Open the affected file and then try to save the changes.
• If you are able to save the changes without any error, then it indicates add-ins are causing the issue. To fix this, you can remove the recently downloaded add-ins (if any).

Method 5: Repair the Excel File

Corruption in Excel file can also create issue while saving the changes. In such a case, you can repair the corrupted Excel file using the inbuilt utility in Excel, named Open and Repair. Follow these steps to use this utility:

• In Excel, navigate to File > Open > Browse.
• In the Open dialog box, click on the affected Excel file.
• Click the arrow next to the Open button and select Open and Repair from the dropdown.
• Click on the Repair option to recover as much data from the file as possible.

If the above utility fails to fix the corrupt Excel file, then you can use a more powerful Excel repair tool , such as Stellar Repair for Excel. This Excel repair tool can repair even severely corrupted or damaged Excel files (xls, .xlsx, .xltm, .xltx, and .xlsm). This tool can recover all the data from the corrupted Excel file, including images, chart sheets, formulas, etc., without changing the original format. It can help in fixing common corruption-related errors in Excel. You can download the software’s demo version to scan the corrupt file.

To Conclude

Above, we have discussed some effective methods to fix the sharing violation error in Excel. This error may also occur if you try to save the Excel file in an incompatible format. So, check the format and try saving the file in a compatible format. If the error occurs due to Excel file corruption, you can repair corrupt Excel file using the Open and Repair tool. If nothing works, then download a third-party Excel repair tool, such as Stellar Repair for Excel. It is an advanced tool that can fix severely corrupted Excel files. You can install this repair tool on any Windows system.

[Solved] : How to Fix MS Excel Crash Issue

Microsoft Excel may stop responding , hang, freeze, or stop working due to several reasons, such as in compatible add-ins. In such a case, you may receive one of the following error messages.

• Excel has stopped working

• Excel is not responding

• A problem caused the program to stop working correctly. Windows will close the program and notify you if a solution is available.

Why Does Excel Keep Crashing?

If Excel keeps crashing on your PC while opening a workbook, saving Excel file, scrolling or editing cells, etc., it indicates a problem with your Excel program or the Excel file.

Microsoft Excel may crash due to any one or more reasons given below,

•  Incompatible Add-Ins
• Outdated MS Excel program
• Conflict with other programs or antivirus tool
•  Excel file created by third party software
• Problem with network connection
•  Combination of Cell formatting and stylings
• Problem with MS Office installation
• Partially damaged or corrupt Excel file

Problems Caused by Excel Crash Issue

Microsoft Excel crash may cause damage to Excel file and also lead to Excel (XLS/XLSX) file corruption.

Such corrupt Excel files can’t be opened or accessed via MS Excel app. If you try to access a corrupt Excel file, MS Excel may fail to open the file or stop responding and crash. Additionally, you may receive the following or similar error message,

In such a case, you should immediately try to recover the Excel file. You may do so by restoring the Excel file from backup or by using an Excel File Repair software. Otherwise, continue following this guide.

How to Solve Excel Crash Issue?

Before heading to solutions, follow these troubleshooting steps to resolve the Excel Crash issue.

Step 1: Copy File to Local Drive

If you are trying to access and edit or view an Excel file from a network drive, try moving the file to local drive. This will help you find if there is something wrong with the file or the network.

Step 2: Ensure Sufficient Memory

Excel files can grow fairly large when you start adding lots of formatting and shapes. Make sure that your system has enough RAM to run the application.

If you often work with large Excel files and complex data values& formulas, then install 64-bit versions of MS Office. It will give you an advantage of larger processing capacities and prevent Excel from crash or freeze.

Step 3: Check If Excel is Open and In Use by Another Process

Open Task Manager and close all processes or apps (tasks) that may be using or have access to your Excel file that you are working on. You can find this detail in status bar of Excel program at the bottom of program window.

After closing the tasks, try to access the Excel file and check if this fixes the performance and crash problem in Excel.

Step 4: Test and Repair Excel File

Create a copy of the Excel file and install Stellar Repair for Excel software. It’s free to download. Scan and repair your Excel file using the software. After repair, save the Excel file at your desired location and then open the Excel file in the MS Excel program.

This should ideally fix all the issues with Excel.

However, if the Excel program still crashes, the problem lies within the system or program. Follow the solutions discussed in this guide to try to fix the Excel crash issue.

NOTE: To save repaired Excel file using the mentioned software, you must purchase the activation key and activate it.

Solutions to Fix MS Excel Crash Issue

Following are some solutions to resolve problems with MS Excel such as,

• Excel not responding
• Excel won’t open
• Excel keeps crashing

Follow these solutions in the given order. In case a method doesn’t work, move to the next one.

Solution 1: Restart Excel in Safe Mode

By starting MS Excel in safe mode, you can run the program without loading the Excel add-ins and with limited features. But COM add-ins are excluded.

To launch Excel in safe mode, close MS Excel and follow these steps,

• Create a shortcut of MS Excel (.exe) on Desktop
• Press and hold the Ctrl key while launching the program
• Click ‘Yes’ when a prompt appears to confirm

Alternatively, press Windows+R, type excel /safe and press ‘Enter’. Use this to open Excel in safe mode on Windows 10, 8.1, 8, or 7 system.

Now try to open and access the Excel file and check if the issue is resolved. If it’s not, head on to the next solution.

Solution 2: Check and Remove Faulty Add-ins

In case Excel doesn’t crash in Safe Mode, it’s possible that some faulty add-ins are the culprit behind frequent Excel crash and freeze. These Excel add-ins may interfere or conflict with the Excel program.

Find and remove the faulty add-in. It can resolve the issue. To do so, follow these steps,

• Restart Excel in normal mode and go to File> Options> Add-ins
• Choose COM Add-ins from the drop-down and click Go

• Uncheck all the checkboxes and click OK

• Restart Excel and check if the issue is resolved
•  If Excel doesn’t crash or freeze anymore, open COM Add-ins and enable one add-in at a time followed by Excel restart. Then observe Excel for freeze or crash problem

This will help you find out the faulty add-in, which is causing the problem. Remove the add-in which is causing the problem to resolve the issue. If that doesn’t fix, move to the next solution.

Solution 3: Check and Install the Latest Updates

If you haven’t set Windows to Download and Install Updates automatically, do it now.

Apart from updating the operating system, latest Windows updates sometimes fixes bugs for other applications installed on the system such as MS Office. Often installing an important update that you might have missed may correct the Excel crash problem.

You can also update MS Office manually. Follow these steps,

Go to File > Account

 Under Product Information, select Update Options and click Update Now

If you have installed MS Excel from Microsoft Store, open the store and update your Office applications.

NOTE: This also works if you can’t open Excel file or Excel crashes after Windows upgrade from Windows 7 or Windows 8/8.1 to Windows 10.

After installing the latest MS Office updates, check if Excel works fine. If not, head to the next solution.

Solution 4: Clear Conditional Formatting Rules

If a sheet is causing Excel to freeze or crash, there might be a problem with that particular sheet. In such a case, you may try clearing the Conditional Formatting rules. The steps are as follows,

• Under Home, click ‘Conditional Formatting > Clear Rules> Clear Rules from Entire Sheet’

• You may repeat this step for all other sheets in the Excel workbook
• Then click File> Save as and save the Sheet as a new file at a different location

This avoids overwriting or making changes to the original Excel file. Once done, try working on the sheet.

If this doesn’t work out, move to the next solution.

Solution 5: Remove Multiple Cell Formatting and Styles

If a workbook is being shared and edited by others on different platforms then it’s possible that many cells are formatted differently. This can cause issues with Excel such as crash and freeze. It can also lead to Excel file corruption. The problem mostly occurs when a workbook contains multiple worksheets using different formatting.

You can follow this guide to remove different cell formats and styles, and then open the Excel file.

Solution 6: Disable Microsoft Excel Animation

Animations require additional processing power and resources. By disabling animations in Excel, you may resolve Excel freeze and crash issue. This also improves MS Excel performance.

To disable the animations in MS Excel, follow these steps:

• Go to File > Options
• Click ‘Advanced’ and check ‘Disable hardware graphics acceleration’animation

• Click ‘OK’ to close the window and then restart MS Excel

This has helped many users in fixing the Excel crash issue. If it doesn’t work for you, head to the next solution.

Solution 7: Check If Excel File is Generated by a Third-Party Application

There are applications which you may have used to generate Excel files to fetch data. For instance, downloading data from Google Analytics in Excel format.

Sometimes, these Excel files are not generated correctly by such third-party apps. Thus, some features in Excel may not work as intended when you access the files in MS Excel.

In such a case, you should get in touch with the app developer for help with the file or use Stellar Repair for Excel to repair such Excel files.

Solution 8: Check If Antivirus or Other Apps are Conflicting with MS Excel

Ensure your antivirus is up-to-date and not conflicting with MS Excel. An outdated antivirus tool may conflict with Excel which can cause the application to hang, freeze, or crash.

• Update your antivirus
• Try disabling the add-in or integration between Excel and antivirus. See if it works

Alternatively, you may disable the anti-virus tool temporarily to check if it is the culprit behind Excel performance issue and crash. If that resolves the problem, get in touch with your antivirus vendor and report the problem.

They might provide you with a better solution or workaround to fix this problem without disabling the antivirus protection.

IMPORTANT NOTE: Disabling or altering antivirus protection makes your PC vulnerable to malicious attacks and virus or malware intrusion.

Solution 9: Clean Boot Windows to Inspect the Cause Behind Excel Crash

When Windows boot, it starts several processes, services, and application during start up automatically, which runs in the background.

These startup apps and services can interfere with other applications such as MS Excel. To find out if that’s the cause behind Excel crash, you can perform a Clean Boot.

This helps you identify processes, services, or applications that are conflicting with Excel. Steps to perform Clean Boot are as follows,

• Press Windows key + R, type MSConfig, and press ‘Enter’
• In System Configuration window, click on the General tab and choose Selective startup

Uncheck ‘Load startup items’ and click ‘OK’

After this, close all running applications and restart your PC

Check if the crash problem with Excel is resolved. Uninstall the conflicting apps or update them. If your issue is not resolved, follow the next solution.

Solution 10: Repair or Reinstall MS Office

Repairing Office programs may also resolve Excel crash issues if caused by damaged MS Excel program or MS Office files. The steps are as follow,

• Close all MS Office apps and open the Control Panel
• Click Uninstall a program under Programs

• Click on Microsoft Office and then click on the Change option
• Choose ‘Quick repair’ and then select ‘Repair’
• Click ‘Continue’ to repair MS Office installation

You may also try ‘Online Repair’ if this fails to fix the issue. After repair, if the Excel issue persists, reinstall MS Office.

Need More Help?

If none of the above-mentioned solutions worked for you, it indicates that the problem is not with the Excel program but with the Excel file. If you haven’t tried the Stellar Repair for Excel software, do it now.

Select the Excel file which is causing the problem and repair it with the software. It’s a powerful Excel repair software that can fix all the problems with Excel files (XLS/XLSX). It repairs corrupt and severely damaged Excel files.

The software is compatible with all Excel files created using MS Excel 2019, 2016, 2013, 2010, 2007, 2003 or 2000.

After repairing and saving the Excel file, you can open it in your MS Excel program and work on it without any performance issue. To know more about this software, visit this page.

[Error Solved] Excel file is not in recognizable format

Summary: Microsoft’s Excel is one of the most widely used spreadsheet tools, however, it isn’t entirely free of errors. There are in fact quite a large number of problems that can crop up in this user-friendly application which can put all work to halt. One such error occurs when Excel does not recognize the file format of .xls or .xlsx file and the error message says “Excel file is not in recognizable format” error. Let us explore this annoying error in detail.

Figure: Error message

From a small shop to the global industry giants, everyone relies on Microsoft Excel to complete their work. Quite a few businesses not only use Excel for their inventory tracking purposes but also to manage task lists and timesheets for their employees and project management charts. With high programming proficiency, one can create macros in excel which help in automating a lot of things. You can create quite a few variations, such as pie charts, bar charts, line graphs, area charts, and many more to showcase the data both in a tabular column as well as in a pictorial representation.

While Excel enjoys wild popularity, thanks to its powerful design and features, it doesn’t mean that Excel is all free of errors. There are actually repetition a few errors that one can encounter. One you might have come across is the error stating “Excel file is not in a recognizable format”.

What is this error all about?

The “Excel file in unrecognizable format error” occurs when the Excel file you are trying to load is corrupted. Microsoft has ensured that the workbook will be recoverable when the file is imported into excel but there are times when the automatic recovery does not happen. That’s where the challenge really lies. In such cases, getting to the root of the issue becomes necessary to be able to solve it.

Reasons behind the error

1. One of the main reasons for the error is that the file must have got corrupted while being transferred from one machine to another.
2. Another reason can be that the latest service pack might not be in use on your system.
3. There could be MS Excel version change.
4. Corruption of the file due to virus infection, extremely large databases, or multiple locks on the file at the same time can also trigger this error.

If you have ever faced this error, you do not need to panic. We have a couple of solutions listed for you when you face the Excel file in an unrecognizable format error.

How do you go about fixing this?

Solution 1: Use MOC.exe file to convert the workbook and then open it in Excel:

1. Right-click on .XLS (you can use any .XLS files in your system).
2. A new dialogue will appear. Here, click on “Choose another app” to select it.

Figure: choose another app

3. You will now be presented with a number of applications which the OS thinks the file format will be compatible with.
4. You do not have to choose any of the prepopulated apps from the list.

Figure: Look for another app

5. Navigate using the Look for another app on this PC  to the path “C:\Program Files\Microsoft Office\OfficeVersion”
6. You will see a file name MOC.exe
7. Choose that and complete your export.
8. Try opening the workbook in Excel and the error should now be resolved.

Solution 2: Opening the file from within the Excel:

1. Open a new Excel workbook.
2. Press “Alt + F” or alternatively, go to the menu.
3. Once you are in the menu, go to Options.
4. You will be able to see a number of tabs on the left side of the options.
5. Under the ‘Formulas’ tab, ensure that the calculation is in Manual mode – this setting is in the automatic mode, by default.

Figure: Manual option

6. Click OK and save the changes to the workbook.
7. Now, browse for the file which was corrupted.
8. Click on the file and then select the option “Open and Repair”. You will find it in the drop down Menu.

Figure: Open and Repair

9. Once the file has been imported, click on “Repair” to recover the data from the selected workbook.

Figure: Repair option

Solution 3: Use automated Excel repair software

If none of the above mentioned manual methods works to eliminate the ‘Excel file in unrecognizable format’ error, it means your Excel file has been severely corrupted and needs professional assistance. In such a scenario, quickly download reliable and competent software Stellar Repair for Excel. Backed by powerful scanning and repair algorithms, this product guarantees up to 100% Excel file repair regardless of the amount of damage in it.

1. Download, install and launch Stellar Repair for Excel.
2. Allow the software to scan the corrupted Excel file.
3. All recoverable data will be listed in a tree-view list. You can select and preview any item from here.
4. Select and recover individual or entire data from the file and save as a new Excel.

This method is currently the easiest and most convenient to resolve miscellaneous Excel errors.

Wrapping it up

Excel is one of the most powerful tools which can easily reduce your workload by more than 75% if used in a proper way. However, if you face complex errors like “Excel file is not in recognizable format”, you can use the methods mentioned above to get rid of it and resume your working in MS Excel. Remember, if the manual solutions don’t work, you can always rely on a proficient software like Stellar Repair for Excel to complete the job with finesse.

How Can I Recover Corrupted Excel File 2016?

Error Messages Indicating Corruption in Excel File

• When an Excel 2016 file turns corrupt, you’ll receive an error message that reads: “The file is corrupt and cannot be opened .”

• But sometimes, you encounter the “Excel cannot open this file” error message due to corruption in the file.

Why does Excel File turn Corrupt?

Following are some common reasons that can turn an Excel file corrupt:

• Large size of the Excel file
• The file is virus infected
• Hard drive on which Excel file is stored has developed bad sectors
• Abrupt system shutdown while working on a worksheet

Workarounds to Recover Data from Corrupt Excel

The workarounds to recover corrupted Excel file 2016 data will vary depending on whether you can open the file or not.

How to Recover Corrupted Excel File 2016 Data When You Can Open the File?

If the corrupt Excel file is open, try any of the following workarounds to retrieve the data:

Workaround 1 – Use the Recover Unsaved Workbooks Option

If your Excel file gets corrupt while you are working on it and you haven’t saved the changes, you can try retrieving the file’s data by following these steps:

• Open your Excel 2016 application and click on the Open Other Workbooks option.

• Click the Recover Unsaved Workbooks button at the bottom of the ‘Recent Workbooks’ section.

• A window with list of unsaved Excel files will open. Click the corrupt file you want to open.

This will reopen your last saved version of the Excel workbook. If this method doesn’t work, proceed with the next workaround.

Workaround 2 – Revert to Last Saved Version of your Excel File

If your Excel file gets corrupt in the middle of making any changes, you can recover the file’s data if the changes haven’t been saved. For this, you need to revert to the last saved version of your Excel file. Doing so will discard any changes that may have caused the file to turn corrupt. Here’s how to do it:

• In your Excel 2016 file, click File from the main menu.
• Click Open. From the list of workbooks under Recent workbooks, double-click the corrupt workbook that is already open in Excel.
• Click Yes when prompted to reopen the workbook.

Excel will revert the corrupt file to its last saved version. If it fails, skip to the next workaround.

Workaround 3 – Save the Corrupted Excel File in Symbolic Link (SYLK) Format

Saving an Excel file in SYLK format might help you filter out corrupted elements from the file. Here are the steps to do so:

• From your Excel File menu, choose Save As.
• In ‘Save As’ window that pops-up, from the Save as type dropdown list, choose the SYLK (Symbolic Link) option, and then click Save.

Note: Only the active sheet will be saved in workbook on choosing the SYLK format.

• Click OK when prompted that “The selected file type does not support workbooks that contain multiple sheets”. This will only save the active sheet.

• Click Yes when the warning message appears - “Some features in your workbook might be lost if you save it as SYLK (Symbolic Link)”.

• Click File > Open.
• Browse the corrupt workbook saved with SYLK format (.slk) and open it.
• After opening the file, select File > Save As.
• In ‘Save as type’ dialog box, select Excel workbook.
• Rename the workbook and hit the Save button.

After performing these steps, a copy of your original workbook will be saved at the specified location.

How to Recover Corrupted Excel File 2016 Data When You Cannot Open the File?

If you can’t access the Excel file, apply one of these workarounds to salvage the file’s data.

Workaround 1 – Open and Repair the Excel File

Excel automatically initiates ‘File Recovery’ mode on opening a corrupt file. After starting the auto-recovery mode, it attempts to reopen and repair the corrupt Excel file at the same time. If the auto-recovery mode does not start automatically, you can try to fix corrupted Excel file 2016 manually by using ‘Open and Repair’. Follow these steps:

• Open a blank file, click the File tab and select Open.
• Browse the location where the corrupt 2016 Excel file is stored.
• When an ‘Open’ dialog box appears, select the file you want to repair.
• Once the file is selected, click the arrow next to the Open button, and then click the Open and Repair button.
• Do any of these actions:
• Click Repair to fix corrupted file and recover data from it.
• Click Extract Data if you cannot repair the file or only need to extract values and formulas.

If performing these actions doesn’t help you retrieve the data, proceed with the next workaround.

Workaround 2 – Disable the Protected View Settings

Follow these steps to disable the protected view settings in an Excel file:

• Open a blank 2016 workbook.

• Click the File tab and then select Options.

• When an Excel Options window opens, click Trust Center > Trust Center Settings.

• In the window that pops-up, choose Protected View from the left side navigation. Under ‘Protected View’, uncheck all the checkboxes, and then hit OK.

Now, try opening your corrupt Excel 2016 file. If it won’t open, try the next workaround.

Workaround 3 – Link to the Corrupt Excel File using External References

If you only need to extract Excel file data without formulas or calculated values, use external references to link to your corrupt Excel 2016 file. Here’s how you can do it:

• From your Excel file, click File > Open.
• From the window that opens, click Computer and then click Browse and copy the name of your corrupt Excel 2016 file. Click the Cancel button.

• Go back to your Excel file, click File > New > Blank workbook.

• In the new Excel workbook, type “=CorruptExcelFile Name!A1” in cell A1 to reference cell A1 of the corrupted file. Replace the ‘CorruptExcelFile Name’ with the name of the corrupt file that you have copied above. Hit ENTER.
• If ‘Update Values’ dialog box appears, select the corrupt 2016 Excel file, and then click OK.
• If ‘Select Sheet’ dialog box pops-up, select a corrupt sheet, and press the OK button.
• Select and drag cell A1 till the columns required to store the data of your corrupted Excel file.
• Next, copy row A and drag it down to the rows needed to save the file’s data.
• Select and copy the file’s data.
• From the Edit menu, choose the Paste Special option and then select Values. Click OK to paste values and remove the reference links to the corrupt file.

Check the new Excel file for recoverable data. If this didn’t work, consider using an Excel file repair tool to retrieve data.

Alternative Solution to Recover Excel File Data

Applying the above workarounds may take considerable time to recover corrupted Excel file 2016. Also, they may fail to extract data from a severely corrupted file. Using Stellar Repair for Excel software can help you overcome these limitations. The software helps repair severely corrupted XLS/XLSX file and retrieve all the file data in a few simple steps.

Key benefits of using Stellar Repair for Excel are as follows:

• Recovers tables, pivot tables, images, charts, chartsheets, hidden sheets, etc.
• Maintains original spreadsheet properties and cell formatting
• Batch repair multiple Excel XLS/XLSX files in a single go
• Supports MS Excel 2019, 2016, 2013, and previous versions

Check out this video to know how the Excel file repair tool from Stellar® works:

Conclusion

Errors such as ‘the file is corrupt and cannot be opened’, ‘Excel cannot open this file’, etc. indicate corruption in an Excel file. Large-sized workbook, virus infection, bad sectors on hard disk drive, etc. are some reasons that may result in Excel file corruption. The workarounds discussed in this article can help you recover corrupted Excel file 2016 data. However, manual methods can be time-consuming and might fail to extract data from severely corrupted workbook. A better alternative is to use Stellar Repair for Excel software that is purpose-built to repair and recover data from damaged or corrupted Excel file.

[Solved] Excel Spreadsheet Disappears after Opening

Several Excel users have reported about experiencing ‘Excel spreadsheet disappears after opening’ issue. The problem occurs when attempting to open an Excel file by double-clicking on the file icon or name. The Excel file opens blank grey screen.

Figure 1 - Excel Blank Screen

User Instances of ‘Excel Open But Can’t See Spreadsheet’ Issue

Instance 1: The user said that “Excel 2016 opens to a blank screen and everything is greyed out. Ribbons at the top of Excel are also not present”.

Instance 2: The user reported that “Attempting to open a spreadsheet, either by double-clicking the file or by opening Excel, it opens but only a blank Excel window is visible. When trying to save that particular file, Excel behaves as though there is no file open at all and all the file saving options, such as save, save as, print, etc. are greyed out.”

Causes Behind ‘Excel Open But Can’t See Spreadsheet’ Issue & the Solutions Thereof

Following are some of the possible reasons behind the ‘Excel open but can’t see spreadsheet’ issue, along with their solutions:

Cause 1: Excel File is Hidden

You may have saved the Excel sheet as a hidden document.

Solution: Unhide Excel File

Verify if your Excel worksheet is hidden by following these steps:

• In Excel, click the View tab, and then click Unhide.

Note: If the ‘Hide’ tab under the View menu is greyed out, the sheet you’re trying to open is not hidden. In that case, proceed to the next workaround.

Figure 2 - Unhide Excel File

• A dialog box will pop-up showing the worksheet name that can be unhidden. For instance, below is an image of Unhide box that lists ‘Daily_Reports’ spreadsheet under Unhide workbook.

Figure 3 – Select and Unhide Excel Workbook

• Click OK to unhide your Excel sheet.

If this fails to work, there’s a possibility that the spreadsheet window pane may have slided to one side of the visible desktop. To bring back the displayed area, click the ‘Arrange All’ option under the View tab. If the issue persists, try the next solution.

Cause 2: Ignore Dynamic Data Exchange (DDE) Option is Enabled

Another reason behind the ‘Excel opens to a blank screen’ issue could be that the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox is checked in Excel options.

Usually, when you double-click an Excel file, a DDE message is sent to Excel instructing it to open that particular file. But, if you have the ‘Ignore DDE’ option selected, the DDE message sent to Excel to open a workbook is ignored. As a result, the Excel workbook opens a blank screen.

Solution: Uncheck the Ignore DDE Option

Make sure that the ‘Ignore DDE’ option is unchecked by performing these steps:

Note: Skip these steps for Excel 2019 and Excel Office 365.

• In your Excel window, click File > Options.

Figure 4 - Select Excel Options

• From the left-side of the ‘Options’ window, choose Advanced.

Figure 5 - Excel Options Window

• In ‘Advanced’ window, locate the General section, and then uncheck the “Ignore other applications that use Dynamic Data Exchange (DDE)” checkbox.

Figure 6 - Uncheck Ignore Other Applications that use DDE

• Click OK to apply the changes.

If these steps don’t work, proceed to the next workaround.

Cause 3: Issue within Office Program

Sometimes, problem within your Microsoft Office program might cause Excel to behave oddly and may result in an Excel spreadsheet disappeared issue.

Solution: Repair Office Program

Try repairing your Office program by executing the steps listed below, based on your Windows OS:

For Windows 10:

• Type Settings in the Windows search box.
• Click Settings.
• In ‘Windows Settings’ screen, select Apps.

Figure 7 - Windows Settings Screen

• In ‘Apps & features’ screen, scroll down to your Microsoft Office program and tap on it, and then click the Modify

Figure 8 - Modify MS Office Program

• In ‘How would you like to repair your Office programs’ dialog box, select the Online Repairradio button, and then click the Repair

Figure 9 - Repair MS Office Program

For Windows 8:

• Open Control Panel and click the Uninstall a program option under Programs.
• Select Microsoft Office 365 and then click Change.
• In the window that opens, select Online Repair and then hit the Repair

You may be asked to restart your system after completion of the repair process.

For Windows 7:

• In ‘Control Panel’ window, double-click Programs and Features.
• Under Uninstall or change a program section, select the Office program, and then select Change.
• In the dialog box that appears, choose Online Repair and then choose Repair.

If repairing your Office installation fails to resolve the issue, continue to solution 4.

Cause 4: Problematic Excel and COM Add-ins

Sometimes, Excel and COM add-ins may cause Excel file open a blank grey screen problem.

Solution: Disable the Add-ins

Disabling the Excel and COM add-ins one at a time may help resolve the problem. The steps are as follows:

• Click the File menu in your Excel file and select
• From ‘Excel Options’ left-side panel, click Add-Ins, and then choose COM Add-ins from the ‘Manage’ drop-down. Click the Go

Figure 10 - Select COM Add-ins

• Uncheck one of the add-ins checkbox from the COM Add-ins window, then select OK.

Figure 11 - Uncheck and Disable COM Add-ins

• Restart your Excel program.

If the issue persists, repeat the above steps (1 till 4), except that you need to choose a different add-in in step 3.

If you’re still experiencing the same problem after unchecking all the COM add-ins, repeat all the above steps, except choose ‘Excel Add-ins’ in step 2.

If Excel can load the file, then the add-in that you disabled last leads to the problem. If turning off add-ins does not work, try the next solution.

Cause 5: Problem with Excel File Associations

The Excel file opening a blank screen problem may occur if the file associations are not performing correctly.

Solution: Reset Excel File Associations

Try resetting the file associations in Excel to their default settings. For this, follow the below steps based on your OS.

For Windows 10 and Windows 8.1:

• Select the file that is opening incorrectly and copy it to the desktop.
• Right-click the file and click Properties.
• In the File’s ‘Properties’ window, check your file type next to Type of Filefrom the General tab. For instance, (.docx), (.csv), or (.pdf).
• Next, check to which app your file is associated with from the Opens withoption

If the file type is different than .xlsx, open the file in a different application by following these steps:

• Click the Change button next to the ‘Opens with’ option.
• Click More apps.
• From the list of applications, select the desired app and then check the Always use this app Click OK.

For Windows 8:

• Open Control Panel, click Default Programs, and then select Set your default programs.
• Choose Excel and then tap the Choose default for this program
• In ‘Set Program Associations’ window, choose Select All and then click Save.

For Windows 7:

• In Control Panel, choose Default Programs.
• Click the Associate a file type or protocol with a specific program
• Choose Microsoft Excel Worksheet and click on change program.
• Choose Microsoft Excel under Recommended Programs.
• If you’re unable to find Excel, browse the Excel installation folder.
• Select exe and then choose Excel.

What Next? Use Stellar Repair for Excel to Recover Your File

If the above solutions don’t help recover your Excel file, use an Excel file repair tool, such as Stellar Repair for Excel to recover it. The software can restore the Excel spreadsheet and its components, including tables, pivot tables, charts, formulas, etc. while preserving the spreadsheet properties and formatting.

Check out the video to recover Excel file by using Stellar Repair for Excel software.

Conclusion

This article described the possible causes behind the ‘Excel open but can’t see spreadsheet’ issue, along with their solutions. The manual solutions to resolve the issue require time and efforts. But, if you need to access your Excel file without any delay, use Stellar Repair for Excel software to recover your .xlsx/.xls file in just a few clicks.

Also read: