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". Let us know if this works. If not, we will see what else we can come up with for you.
6. One more way is paid, but if nothing helps it will be useful Recovery Toolbox for Excel https://repairexcel.recoverytoolbox.com/