Main Content

Add-In Setup

ConfigureMicrosoftExcel

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

If you useMicrosoft Excel2007:

  1. Clickthe Microsoft Office button.

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

If you useMicrosoft Excel2010 and later versions:

  1. SelectFilefrom the main menu.

  2. ClickOptions. The Excel Options dialog box opens.

The next steps are the same for both versions:

  1. ClickAdd-Ins.

  2. From theManageselection list, chooseExcel Add-Ins.

  3. ClickGo. The Add-Ins dialog box opens.

  4. ClickBrowse.

  5. Selectmatlabroot\toolbox\exlink\excllink.xlam. (matlabrootreturns the full path to the folder where MATLAB®is installed.)

  6. ClickOpen. In the Add-Ins dialog box, theSpreadsheet Link for use with MATLAB and Excelcheck box is selected.

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

  7. ClickOKto close the Add-Ins dialog box.

  8. ClickOKto close the Excel Options dialog box.

The Spreadsheet Link add-in loads now and with each subsequent Excel session.

TheMATLAB Command Windowbutton appears on the Microsoft Windows®taskbar.

The MATLAB group appears on the top right of theHometab 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 theRequire Application Add-ins to be signed by Trusted Publishercheck box selected, then you must click theEnable Contentbutton for every session.

To check the settings in the Trust Center dialog box:

  1. Click theDevelopertab.

  2. In theCodegroup, click theMacro Securitybutton. The Trust Center dialog box opens.

  3. Click插件.

Work withExcelMacros

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

If you useMicrosoft Excel2007:

  1. Clickthe Microsoft Office button.

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

If you useMicrosoft Excel2010 and later versions:

  1. Click theFilemenu.

  2. ClickOptions. The Excel Options dialog box opens.

The next steps are the same for both versions:

  1. ClickCustomize Ribbon.

  2. From theMain Tabslist, selectDeveloperand clickOK. The Excel ribbon displays theDevelopertab.

  3. In theCodesection of theDevelopertab, clickMacros. The Macro dialog box opens. Use this dialog box to run existing macros, create macros, and edit and delete macros.

Work withMicrosoftVisual BasicEditor

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

  1. Open a Visual Basic session. Click theVisual Basicbutton on theDeveloper选项卡,或按Alt+F11.

    Note

    For instructions about displaying theDevelopertab, see Excel Help.

  2. In the Visual Basic toolbar, selectTools>References.

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

  4. ClickOK.

See Also

Related Topics