Hi MatLab gurus

I have a problem that is causing significant frustration as after some time digging these posts, help files and my own troubleshooting I cannot seem to reach the bottom of this issue.

My question is about the process that happens when 'xlsread' goes to open a file.  More often than not, the error message "Excel is not responding" pops up that I have to manually click through (clicking 'close'). After the execution of the .m file completes the code seems to have filled the workspace with the correctly pointed to data although having multiple issues opening/closing excel.

Afterward executing the .m file, a 'Excel.exe' process (and only does this intermittently happen) still remains within the task manager as being active, while there is no actual excel application open in my taskbar.

I am running a .m file that 1. reads from excel 2. does a simevents simulation and 3. exports the resulting simulation outputs back into another excel document.  On the 'xlswrite' portions of the code the same thing happens.  More "Excel is not responding" that requires more click throughs.

This is a significant pain to the automation of the process as these 'popups' mean that I have to manually sit in front of the computer while a monte carlo undergoes a number of iterations.

So my question is - Is there a solution to this, it seems the board is full of Excel problems without a definite response from MathWorks as to the state of this simple command that causes so much trouble. 

I look forward to your responses.

I use Vista, 7.10.0 (Matlab, Simulink and SimEvents), Office 2010 all in 32 bit. A generic sample of my code that is generating errors is below:

A=xlsread('file.xlsm','Sheet1','C1:C4000');
B=xlsread('file.xlsm','Sheet1','D1:D4000');
C=xlsread('file.xlsm','Sheet1','E1:E4000');
D=xlsread('file.xlsm','Sheet1','F1:F4000');

"Matthew " <mcdmj96@yahoo.co.uk> wrote in message <i500sd$ngq$1@fred.mathworks.com>...
> Hi MatLab gurus
> 
> I have a problem that is causing significant frustration as after some time digging these posts, help files and my own troubleshooting I cannot seem to reach the bottom of this issue.
> 
> My question is about the process that happens when 'xlsread' goes to open a file.  More often than not, the error message "Excel is not responding" pops up that I have to manually click through (clicking 'close'). After the execution of the .m file completes the code seems to have filled the workspace with the correctly pointed to data although having multiple issues opening/closing excel.
> 
> Afterward executing the .m file, a 'Excel.exe' process (and only does this intermittently happen) still remains within the task manager as being active, while there is no actual excel application open in my taskbar.
> 
> I am running a .m file that 1. reads from excel 2. does a simevents simulation and 3. exports the resulting simulation outputs back into another excel document.  On the 'xlswrite' portions of the code the same thing happens.  More "Excel is not responding" that requires more click throughs.
> 
> This is a significant pain to the automation of the process as these 'popups' mean that I have to manually sit in front of the computer while a monte carlo undergoes a number of iterations.
> 
> So my question is - Is there a solution to this, it seems the board is full of Excel problems without a definite response from MathWorks as to the state of this simple command that causes so much trouble. 
> 
> I look forward to your responses.
> 
> I use Vista, 7.10.0 (Matlab, Simulink and SimEvents), Office 2010 all in 32 bit. A generic sample of my code that is generating errors is below:
> 
> A=xlsread('file.xlsm','Sheet1','C1:C4000');
> B=xlsread('file.xlsm','Sheet1','D1:D4000');
> C=xlsread('file.xlsm','Sheet1','E1:E4000');
> D=xlsread('file.xlsm','Sheet1','F1:F4000');

Based on numerous other threads recently, there seem to be issues with Excel-related functions using Office 2010.  Specifically, actxserver seems to have a problem, and xlsread and xlswrite both use actxserver.  The reason people get no response from MathWorks is because, even though it has frequently been recommended, people do not seem to want to contact technical support.

I suggest you contact technical support.  However, on the off-chance that there's a more simple problem going on, you might want to check that no instance of Excel is running when you start your simulation, and that no cell in a spreadsheet is ever being edited (manually) when your code tries to write to it.

"Matthew " <mcdmj96@yahoo.co.uk> wrote in message 
news:i500sd$ngq$1@fred.mathworks.com...
> Hi MatLab gurus
>
> I have a problem that is causing significant frustration as after some 
> time digging these posts, help files and my own troubleshooting I cannot 
> seem to reach the bottom of this issue.

*snip*

In that case, I recommend you contact Technical Support.  [For instructions 
on how to do so, read my signature below.]

-- 
Steve Lord
slord@mathworks.com
comp.soft-sys.matlab (CSSM) FAQ: http://matlabwiki.mathworks.com/MATLAB_FAQ
To contact Technical Support use the Contact Us link on 
http://www.mathworks.com