To use Spreadsheet Link™, you must install Microsoft® Excel® first, and then install Spreadsheet Link. Ensure that you use the correct MATLAB® version based on the supported version of Excel. After Spreadsheet Link is installed on your computer, you must set up the Spreadsheet Link add-in in Excel.
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.
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.
Use the following table to determine the correct MATLAB version to install, based on the version of Excel installed on your computer. Each row in the table matches the MATLAB version with the supported versions of Excel.
|MATLAB Version||Excel Versions|
|R2016b and later||2019, 2016, 2013, 2010, 2007|
|R2013b||2013, 2010, 2007|
The MATLAB root folder,
matlabroot, is where
MATLAB is installed on your system.
Link installation program creates a subfolder under
exlink folder contains these files:
excllink.xlam: The Spreadsheet
Link add-in for Microsoft
Link example files described in this documentation
If MATLAB and Spreadsheet Link are installed on your computer, to upgrade to a newer version:
Install the new version of MATLAB and Spreadsheet Link.
Start MATLAB and a Microsoft Excel session.
Configure the Spreadsheet Link software. For details, see Add-In Setup.
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:
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.)
In the left pane, select a module for which you want to update a reference.
From the main menu, select Tools > References.
In the References dialog box, select the SpreadsheetLink2007_2010 check box.