To solve the issue of Word or Excel not open properly while performing some important tasks, just follow the steps given below:
1) With the help of Open and Repair tab, you can repair your files.
2) Data Extraction is also the other way to solve the problem of Word or Excel filed not opening properly.
3) By utilizing Microsoft Office Tools, you can get rid of this problem.
Source: http://www.repairmsexcel.com/blog/repair-corrupt-excel-workbook