If you cannot open an Excel file and see Excel cannot open the file because the file format or extension is not valid error, see this post.

If Excel fails to repair the workbook when you select the "Repair" option, open the file again using "Open and Repair," but this time select "Extract Data" instead.

Excel may not display the XLS file if another option is selected, giving you the impression that it can't open it.