A general workaround would be to convert the XLS to CSV and then load the CSV.
Regarding the root cause, this may have multiple reasons why you see the observed symptoms:
- Not really a XLS flie, some applications such as Salesforce create HTML files and relabel them as XLS.
- Corrupt XLS file, row count can't be >65536.
- Complex formatting (filtering) and referencing may cause similar issues