error message: unexpected record length

I have an excel file 65000 x 4 which is already saved as .xls (as opposed to .xlsx). I cannot read the file because of the above error message. It tells me to save it as Excel 98, but it already is! I don't know what to do with this. How to solve this problem?

Answer 1

[Jan]

The row limit of 65535 is not the problem. Some Mac users explained in the past, that their xlsread failed, when the cells contain special characters like ° . Try to remove these characters. Saving the file as XLSX might help also.

Please mention your OS and Matlab version.

See https://de.mathworks.com/matlabcentral/newsreader/view_thread/239302.

Answer 2

[cgo]

I am using a mac, with matlab 2013b.

I havent completely scanned the file, but I don't know where I could have placed a special character there.