Documentation Center

  • Trial Software
  • Product Updates

Installation

Product Installation

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

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

    To install the Spreadsheet Link EX 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 EX installation program creates a subfolder under matlabroot\toolbox\. The exlink folder contains these files:

  • excllink2003.xla: The Spreadsheet Link EX Add-In for Microsoft Excel 2003 and earlier

  • excllink.xlam: The Spreadsheet Link EX Add-In for Microsoft Excel 2007 and later

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

Spreadsheet Link EX uses Kernel32.dll, which should already be in the appropriate Windows® system folder (for example, C:\Winnt\system32). If not, consult your system administrator.

After You Upgrade the Spreadsheet Link EX Software

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

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

  2. Start MATLAB and a Microsoft Excel session.

  3. Configure the Spreadsheet Link EX software.

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

To update the references in an existing workbook in Microsoft Excel 2003 and earlier:

  1. In a Microsoft Excel session, open the Visual Basic® Editor window by selecting Tools > Macros > Visual Basic Editor.

  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 SpreadsheetLinkEX check box.

  5. Click OK.

To update the references in an existing workbook in Microsoft Excel 2007 and later:

  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.

Was this topic helpful?