That error message really gives the impression that you are not reading a true Excel file. Did you create it or did it come from somewhere else?
Excel is rather notorious for labelling things that Excel and only Excel can open as if it were an Excel file.
You might try exporting a sheet as a .csv file and try loading that with read.csv or read_csv.