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

add-insexcellinkmultipleregisterregserverSpreadsheet Linkversions

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?

Best Answer

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.

Related Solutions

MATLAB: Does the installation of the Excel Link / Spreadsheet Link EX Addin not create a MATLAB toolbar/group

1. Make sure you are using a supported combination of MATLAB release and MS Office release, referring to the getting started section in the documentation:

docsearch('excel link getting started')

2. Follow the steps of installation instructions in the getting started section of the documentation.

3. Make sure you are using the right Addin file (according to your MS Office version).

4. Before you install the Addin make sure the security settings in Excel are not disabling Macros and Addins.

5. If MATLAB does not open immediately after installing the Addin, check if MATLAB is registered as an Automation Server. You can verify this by saving the the following VBS code:

Set MatlabObject = CreateObject("Matlab.Application")
MatlabObject.Visible = 1
MsgBox "Done"

to a .vbs script and run the script (double click). If MATLAB is registered as a COM Server a message box will pop up. Otherwise run the command 'regmatlabserver' in MATLAB, and install the Addin again.

6. If the installation still does not succeed, reset the Microsoft Office User Profile and try again.

MATLAB: How to get or puchase the Matlab Spreadsheet link For Excel

Do you see "Spreadsheet Link" in the Add-Ons list? It should be in the Computational Finance section under the Application Products category.

Best Answer

Related Solutions

MATLAB: Does the installation of the Excel Link / Spreadsheet Link EX Addin not create a MATLAB toolbar/group

MATLAB: How to get or puchase the Matlab Spreadsheet link For Excel

Related Question