By default, Spreadsheet Link EX starts a new MATLAB session. Alternatively, it can connect to an already running MATLAB session.
To connect a new Excel session to already running MATLAB session:
1. In MATLAB, enter the following command:
enableservice('AutomationServer', true)
This command converts a running MATLAB session into an automation server. Re-execute this command until returns 1.
2. In Excel file, click MATLAB=> Start MATLAB
3. Then you will be able to run other options like "Send data to MATLAB"
For more information on this, see the following URL:
or type the following at the MATLAB prompt:
web([docroot '/toolbox/exlink/bq8lkxb.html'])
Best Answer