Documentation

This is machine translation

Translated by Microsoft
Mouseover text to see original. Click the button below to return to the English verison of the page.

Note: This page has been translated by MathWorks. Please click here
To view all translated materals including this page, select Japan from the country navigator on the bottom of this page.

Add-In Setup

Configure Microsoft Excel

To enable the Spreadsheet Link™ 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 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 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.

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 the 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 or SpreadsheetLink2007_2010 check box.

  4. Click OK.

See Also

Related Topics

Was this topic helpful?