Main Content

Add-In Setup

Configure Microsoft Excel

To enable the Spreadsheet Link™ add-in, start a Microsoft® Excel® session and follow these steps.

For Microsoft Excel 2013 and later versions:

  1. Select File from the main menu.

  2. Click Options. The Excel Options dialog box opens.

  3. Click Add-Ins.

  4. From the Manage selection list, choose Excel Add-Ins.

  5. Click Go. The Add-Ins dialog box opens.

  6. Click Browse.

  7. Select matlabroot\toolbox\exlink\excllink.xlam. (matlabroot returns the full path to the folder where MATLAB® is installed.)

  8. Click Open. In the Add-Ins dialog box, the Spreadsheet Link for use with MATLAB and Excel check box is selected.

    Add-Ins dialog box containing a list of Excel add-ins

  9. Click OK to close the Add-Ins dialog box.

  10. 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.

MATLAB group that contains Spreadsheet Link functionality and preferences

Spreadsheet Link is ready for use.

Right-click a cell to list the MATLAB options.

MATLAB options that contain Spreadsheet Link functionality

Note

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:

  1. Click the Developer tab.

  2. In the Code group, click the Macro Security button. The Trust Center dialog box opens.

  3. Click Add-ins.

Work with Excel Macros

To work with Excel macros, follow these steps to enable the Developer tab on the Excel ribbon.

For Microsoft Excel 2013 and later versions:

  1. Click the File menu.

  2. Click Options. The Excel Options dialog box opens.

  3. Click Customize Ribbon.

  4. From the Main Tabs list, select Developer and click OK. The Excel ribbon displays the Developer tab.

  5. In the Code section of the Developer tab, click Macros. The Macro dialog box opens. Use this dialog box to run existing macros, create macros, and edit and delete macros.

Work with Microsoft Visual Basic Editor

To enable Spreadsheet Link as a Reference in the Microsoft Visual Basic® Editor:

  1. Open a Visual Basic session. Click the Visual Basic button on the Developer tab, or press Alt+F11.

    Note

    For instructions about displaying the Developer tab, see Excel Help.

  2. In the Visual Basic toolbar, select Tools > References.

  3. In the References — VBA Project dialog box, select the SpreadsheetLink check box.

  4. Click OK.

See Also

Related Topics