This is machine translation

Translated by Microsoft
Mouse over text to see original. Click the button below to return to the English verison of the 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?