Documentation

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.

Installation

Product Installation

Install the Microsoft® Excel® product before you install the MATLAB® and Spreadsheet Link™ software. To install the Spreadsheet Link Add-In, follow the instructions in the MATLAB installation documentation. Select the Spreadsheet Link check box when choosing components to install.

    Notes:   If you have several versions of MATLAB installed on your computer, Spreadsheet Link uses the version that you registered last.

    To install the Spreadsheet Link Add-In, you need administrator system privileges on the computer. Contact your system administrator to enable these privileges.

Files and Folders Created by the Installation

    Note:   The MATLAB root folder, matlabroot, is where MATLAB is installed on your system.

The Spreadsheet Link installation program creates a subfolder under matlabroot\toolbox\. The exlink folder contains these files:

  • excllink.xlam: The Spreadsheet Link Add-In for Microsoft Excel

  • ExliSamp.xls: Spreadsheet Link example files described in this documentation

After You Upgrade the Spreadsheet Link Software

If MATLAB and Spreadsheet Link are installed on your computer, to upgrade to a newer version:

  1. Install the new version of MATLAB and Spreadsheet Link.

  2. Start MATLAB and a Microsoft Excel session.

  3. Configure the Spreadsheet Link software. For details, see Add-In Setup.

  4. If you have existing workbooks with macros that use Spreadsheet Link, update references to Spreadsheet Link in each workbook.

To update the references in an existing workbook in Microsoft Excel:

  1. In a Microsoft Excel session, open the Visual Basic® Editor window by clicking Visual Basic on the Developer tab. (If you do not find the Developer tab, see the Excel Help.)

  2. In the left pane, select a module for which you want to update a reference.

  3. From the main menu, select Tools > References.

  4. In the References dialog box, select the SpreadsheetLink2007_2010 check box.

  5. Click OK.

More About

Was this topic helpful?