xlsread - suppress opening Excel window (R2014a)

I recently installed R2014a and MS Office Home 2013 64bit.

When I run xlsread, it briefly opens an Excel window (visible to the user). The data loads fine, but this is visually annoying and unnecessary. It also slows the code slightly.

This didn't occur with my previous installation of R2013a with MS Office 32bit. Does anybody know what is causing this? Perhaps it's the new Matlab or the 64bit Excel.

Thanks for the help! Joe

Sample code

xlsread('filename.xls');

[dpb]

That sounds like issue to submit to TMW official support at www.mathworks.com

[Bruno Pop-Stefanov]

Does it do that on any Excel spreadsheet or only on the same one? Can you try with a blank spreadsheet? Does the spreadsheet contain macros (e.g., MATLABINIT)? Are there any errors printed in the Command Window?

[Lena]

I have the same problem working with MS Office Professional Plus 2013 and Matlab 2014b. I tried it with an empty sheet, but the window still opens. Any ideas?

Answer 1

[Image Analyst]

I don't recall observing that. You could always use ActiveX and set the visible property to off before it opens. I have an ActiveX Demo attached.

[Marco]

Thanks for the nice demo file! You got my vote for this.

[Image Analyst]

You're welcome Marco. Joe can also vote, plus officially "Accept" the answer if it helped him.

[Lena]

I set the visibility property to false, but every xlsread command leads to a short opening and closing of the respective excel worksheet.

[Image Analyst]

Lena, post your code and explanation in a new question. Perhaps it's just happening so fast.