xlsread sheet read problem

Hi!

I was trying to use xlsread to import excel files with multiple sheet. My aim is read data from each sheet, concate them and make graphs from there. The program read in 1st and 2nd sheet well but on the 3rd sheet, it gives this error:

"Error using xlsread (line 245) XLSREAD unable to read sheet 'SortedData(3)'. File contains unexpected record length. Try saving as Excel 98."

Even though the Excel file is already saved as the 97-04 format and even when all the sheets are identical (when I duplicated the first sheet and deleted the rest).

Anyone has any idea what the problem is? Is it possible that the dataset is too big for matlab to handle? (I have about two thousand items on each sheet. But this doesn't seem to be right because even if I try to run the code only on the 3rd or 4th sheet, matlab can't seem to read in the sheet properly).

Any help/suggestions much appreciated! (version: R2012a (7.14.0))

[Anqi Li]

same problem here. I'm using MATLAB R2014a on Mac. Please help me.