If you cannot open the Excel file from its location, simply open any Excel file and click the File tab. Then, go to Open > Browse and select the file giving error ...
Whenever I try to export to XLS or XLSX, Excel cannot open the file. Exporting via CSV or HTML does work. I even deleted all the data from the export, and exporting an empty sheet still does not work.