Here are top 5 recommended methods that help you to recover data from corrupt MS Excel file: 1: Try to repair it manually when MS Excel does not automatically starts File recovery mode.  Click the Microsoft Office Button, and then click Open. Now select the corrupted workbook that you want to open. Click the arrow next to the Open button, and then click Open and Repair. Choose either ms excel xlsx repair tool (to recover as much of the file data) or Extract data (to extract values and formula when repair process is not successful).   2: Open with Open Office: Try to open your Excel file in Open Office. It is an open-source Office suite that is able to open & save Microsoft Excel files. 3: Save in HTML Format: Open your Excel file and save it in HTML format. By saving the workbook in HTML format, you may be able to filter out the corrupted elements. 4: Save in SYLK Format: Open your Excel file and save it in SYLK format. By saving the workbook in SYLK format, you may be able to filter out the corrupted elements. 5: Try 3rd party software
What is the problem?  I could not open the file that I needed at work for an important report. In Excel 2016, I found an error unknown to me - Microsoft Excel has encountered a problem and needs to close. Tell me, can I open it and how? This is very important, because technical support was not able to help me to solve such problems.
I could not open the file that I needed at work for an important report.