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 ...

Select "Save link as..." Note the location where this file will be saved. Start Excel. Open the file using the open command. A dialog box will ask you a couple of questions and you are ready to go.