To enable the Spreadsheet Link™ add-in, start a Microsoft® Excel® session and follow these steps.
If you use Microsoft Excel 2007:
Click , the Microsoft Office button.
Click Excel Options. The Excel Options dialog box opens.
If you use Microsoft Excel 2010 and later versions:
Select File from the main menu.
Click Options. The Excel Options dialog box opens.
The next steps are the same for both versions:
From the Manage selection list, choose Excel Add-Ins.
Click Go. The Add-Ins dialog box opens.
matlabroot returns the full path to the folder where
MATLAB® is installed.)
Click Open. In the Add-Ins dialog box, the Spreadsheet Link for use with MATLAB and Excel check box is selected.
Click OK to close the Add-Ins dialog box.
Click OK to close the Excel Options dialog box.
The Spreadsheet Link add-in loads now and with each subsequent Excel session.
The MATLAB Command Window button appears on the Microsoft Windows® taskbar.
The MATLAB group appears on the top right of the Home tab in your Excel worksheet.
Spreadsheet Link is ready for use.
Right-click a cell to list the MATLAB options.
If the options are missing from the context menu and if the Trust Center dialog box has the Require Application Add-ins to be signed by Trusted Publisher check box selected, then you must click the Enable Content button for every session.
To check the settings in the Trust Center dialog box:
Click the Developer tab.
In the Code group, click the Macro Security button. The Trust Center dialog box opens.
To enable Spreadsheet Link as a Reference in the Microsoft Visual Basic® Editor:
Open a Visual Basic session. Click the Visual Basic button on the Developer tab, or press Alt+F11.
For instructions about displaying the Developer tab, see Excel Help.
In the Visual Basic toolbar, select Tools > References.
In the References — VBA Project dialog box, select the SpreadsheetLink or SpreadsheetLink2007_2010 check box.