Why is MATLAB not started automatically and the Excel sheet not updated when I open it after installing a new Excel Link version?

I have multiple versions of MATLAB and Excel Link/Spreadsheet Link EX installed on my machine. I have added the new Excel Link Add-Ins version but an older version of MATLAB launches with Excel even though I have updated the Excel Link/Spreadsheet Link EX plug-in. How do I set up my newer version of MATLAB to launch with Excel?

Answer 1

[MathWorks Support Team]

The version of MATLAB that launches with Excel Link/Spreadsheet Link EX is the last one that was registered as a COM server. This is typically done after MATLAB is installed. However, you can manually over ride this by using the following steps.

1. Launch the version of MATLAB that you would like to start up when Excel Starts.

2. Execute the following line of code at the MATLAB command prompt:

!matlab /regserver

A COM server version of MATLAB will start on the toolbar. You can close the COM server version and the client. Then restart Excel, and if needed click the “Start MATLAB” button in the Spreadsheet Link EX toolbar.