MATLAB: Do I get a ‘Please register MATLAB Software as a COM Server’ message in Excel after setting up the Excel Spreadsheet Link Add-In

comexcellinkMATLABserverspreadsheetSpreadsheet Link

When trying to start MATLAB through Excel, I keep getting the error message:

MATLAB Startup Error
Unable to start MATLAB. Please register MATLAB Software as a COM Server.

I have already set up the Excel Spreadsheet Link Add-In. Why do I keep receiving this error message?

Best Answer

If the MATLAB version is set incorrectly, MATLAB does not start and displays this error: Unable to start MATLAB. Please register MATLAB Software as a COM Server. Set the MATLAB version using <https://www.mathworks.com/help/exlink/mlprogramid.html MLProgramId>.

Ensure that the correct MATLAB version appears in the Preferences dialog box before starting MATLAB. For details, see <https://www.mathworks.com/help/exlink/setting-spreadsheet-link-preferences.html Setting Spreadsheet Link Preferences>.

If MATLAB is installed on your computer and setting the MATLAB version does not work, use the last registered version to start MATLAB. To specify the last registered version of MATLAB:

Shut down all MATLAB and Excel® sessions.
Open a command prompt window, and using cd, change to the bin\win64 subfolder of the MATLAB installation folder.
Enter the command:

.\matlab /regserver

Related Solutions

MATLAB: Is MATLAB or Excel unresponsive after invoking MATLAB using the Spreadsheet Link EX plugin

This error may occur if MATLAB is not set up correctly to communicate with Excel. To rectify this, you need to:

a) Register MATLAB as a COM server to be used with Excel.

b) Ensure the correct Add-in is loaded into Excel and selected.

To register a certain MATLAB version as the default server, execute the following command in the MATLAB Command Window of your desired version, as specified in the related article:

Why is the wrong MATLAB version started when using Excel Link?

http://www.mathworks.com/matlabcentral/answers/96393

!matlab -regserver

Equivalently, you can execute the following in the Windows Command Prompt. Please note you must be logged in with administrator privileges to run this command:

C:\Program Files\MATLAB\R20XXx\bin\win64\matlab.exe -regserver

To ensure the correct Add-in for this version of MATLAB is loaded into Excel, follow the instructions in the link below:

https://www.mathworks.com/help/exlink/add-in-setup-1.html

The configuration of Excel with MATLAB will vary based upon the version of Microsoft Office/Excel you have installed. Please refer to the directions for your version of Excel in the walkthrough (linked above).

MATLAB: Is MATLAB not started automatically and the Excel sheet not updated when I open it after installing a new Excel Link version

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.

Best Answer

Related Solutions

MATLAB: Is MATLAB or Excel unresponsive after invoking MATLAB using the Spreadsheet Link EX plugin

MATLAB: Is MATLAB not started automatically and the Excel sheet not updated when I open it after installing a new Excel Link version

Related Question