Hi,
The following steps might help recover your file:
1. Click the File menu
2. Click Open
3. Locate the file, but do not click the Open button. Instead, click the drop-down arrow next to the Open button.
4. Click "Open and Repair"
5. In the dialog that pops up, choose "Repair". If that does not work, try the "Extract Data".
6. Let us know if this works. If not, we will see what else we can come up with for you.

In such a cases where the recovery function are not work properly in Microsoft Excel that you can use the effective third-part tool. XLS Repair Kit offers an easy way of workbook recovery excel file, suitable for any version of MS Excel application in use and you can also use a trial version of utility.

Demo: http://www.xls.repair/

Thanks,