Why can't I start MATLAB with the Excel and why does a registry configuration error occur?

I'm trying to link excel with Matlab. But when I try sending data to MATLAB, only the command window appear. I read online to try run the code:

!matlab /regserver

in the command window, but a registry configuration error occurs. I have MATLAB R2022b. Please advice!

I was able to link Excel and MATLAB before, so I'm not sure why this happens.

Thanks in advance.

Answer 1

[Shivang]

Hi Trang,

I understand you only see the Command Window while sending data to MATLAB using Spreadsheet Link.

Note that only the Command Window opens by default when Spreadsheet Link starts MATLAB in Excel. In order to start MATLAB in full desktop mode, you need to enable the "Use MATLAB desktop" option in the Spreadsheet Link Preferences. Refer to the documentation for more details: https://www.mathworks.com/help/exlink/set-spreadsheet-link-preferences.html

Since you are able to open the Command Window (which is the default behaviour), I doubt there are any issues with your MATLAB COM Server Registration. You can run

comserver('query')

to displays installation paths of the registered MATLAB COM servers, and verify that they correspond to R2022b. Refer to the documentation of the "comserver" function for further details: https://www.mathworks.com/help/matlab/ref/comserver.html

Hope this helps.

Regards,

Shivang