Add-In Setup

Configure Microsoft Excel 2003 and Earlier

To enable the Spreadsheet Link™ EX Add-In:

  1. Start Microsoft® Excel®.

  2. Select Tools > Add-Ins. The Add-Ins dialog box opens.

  3. Click Browse.

  4. Select matlabroot\toolbox\exlink\excllink2003.xla.

      Note:   Throughout this document the notation matlabroot is the MATLAB® root folder, which is where MATLAB is installed on your system.

  5. Click OK.

    In the Add-Ins dialog box, the Spreadsheet Link EX for use with MATLAB check box is selected.

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

The Spreadsheet Link EX Add-In loads now and with each subsequent Excel session.

The MATLAB Command Window button appears on the Microsoft Windows® taskbar.

The Spreadsheet Link EX toolbar appears on your Excel worksheet.

Spreadsheet Link EX is ready for use.

Configure Microsoft Excel 2007 and Later

To enable the Spreadsheet Link EX Add-In, start a Microsoft Excel session and follow these steps.

If you use Microsoft Excel 2007:

  1. Click , the Microsoft Office button.

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

If you use Microsoft Excel 2010 and later versions:

  1. Select File from the main menu.

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

The next steps are the same for both versions:

  1. Click Add-Ins.

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

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

  4. Click Browse.

  5. Select matlabroot\toolbox\exlink\excllink.xlam.

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

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

  8. Click OK to close the Excel Options dialog box.

The Spreadsheet Link EX 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 EX is ready for use.

Right-click a cell to list the MATLAB options.

    Caution   Simultaneously using Add-Ins for 2003 and 2007 and later, referenced in Excel 2007 and later, causes problems with the context-sensitive menu. Use only one Add-In at a time to avoid this issue.

Work with the Microsoft Visual Basic Editor

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

  1. Open a Visual Basic session.

    • If you are running Excel 2003, select Tools > Macro > Visual Basic Editor.

    • If you are running Excel 2007 and later, 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 SpreadsheetLinkEX or SpreadsheetLink2007_2010 check box.

  4. Click OK.

See Also

Was this topic helpful?