Loading Excel documents through COM

Hi,

I've been having problem loading excel documents using importdata or xlsread. The latest error message is: "Invoke Error, Dispatch Exception: Out of present range." It seems to work on some excel files but not others, all are about 2-3Mb. I'm loading the whole file. TReleaseFileName = 'Version_8_Master BoM_L538 15MY China_issue_7july2013.xlsx'; [TBOM, ~] = importdata(TReleaseFileName);

I have looked into this and apparently the command works through something called the COM, which I don't understand. Other than it's something to do with the link between excel, windows and matlab. I've also come to understand that the problem is linked to windows 32 or 64 bit. So I'm now establishing the windows version using "computer", but once I know the windows version how do I feed that into importdata?

Windows version: Windows XP, 32 bit. Matlab: 2013a Excel files are .xlsx files Excel version is unknown but its a pretty new if not the latest version.

Does anyone have any ideas?

Thanks in advance.

Greg