File looks like corrupt, as you said that Open & Repair is unable to fix. At this stage I would recommend you a third party Excel repair software offered by Stellar Phoenix. It is a paid software and repairs corrupt Excel files (.xls & .xlsx).

Note: Before going to buy any software, first install the trial version & see the preview of your data.