xlsread uses ''basic mode'' on windows with excel

Hey guys! Everytime I do:

endnumData=xlsread('data.xlsx')

I get an error,that says:

Warning: Could not start Excel server for import, 'basic' mode will be used. Refer to HELP
XLSREAD for more information. 
> In xlsread at 186

Going to line 186 in the editor and changing the string value

basicMode = true;

only gives more mistakes. Any way to fix this ,so that I don't have to use basic mode all the time.

[Image Analyst]

What Excel version do you have? Is it the "Starter Edition"?

[Kokalz]

I am using Microsoft Office Standart 2010

Answer 1

[Nirmal]

I think it is because you used xlsx file if you use xls you should be fine.

Answer 2

[Kokalz]

I tried both .xlsx and .xls, the problem still persists. The issue seems to be with the COM server that Matlab uses for Excel. I am using 32-bit Excel and 64-bit Matlab on Windows XP 64-bit PC. The bit difference is probably not the reason as this is an exe COM server not the dll one. Could someone help me out please??? It's really important!!!

Answer 3

[Simon Woodward]

I have the same problem. I have Matlab R2009b and Excel Professional 2010. My IT guy said it could be DLLs hanging around from old versions of Excel and confusing Office.

[Image Analyst]

Tell your IT guy to uninstall any old versions of Excel. Also try to upgrade your 5 year old version of MATLAB if you can. I have MATLAB R2014a and Excel 2010 and it all works fine.

Answer 4

[Xiaolong Jin]

I solved this problem by changing the properties of Excel. Right click on Excel--select properties--click the 'compatibility'Tab--tick the 'run this program in compatibility mode for'-- select 'windows 7' or other options. Hope it works!