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.

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

More About

Was this topic helpful?