You entered a formula incorrectly. Common errors include a space between
the function name and the left parenthesis; or missing, extra, or mismatched
If you use the Spreadsheet Link™ software with a non-English (
Windows® desktop environment, certain syntactical elements might not
work. For details, see Localization Information.
Review the entry and correct typing errors.
Can't find project or
Compile error: Sub or
Function not defined
You executed a macro and the location of
excllink.xlam is incorrect or not specified.
Click OK. The References window opens. Remove the
check mark from
MISSING: excllink.xlam. Find
excllink.xlam in its correct location, select its check box
in the References window, and click OK. Or, select > to open the References window. Select the box named
Run-time error '1004': Cells method of
Application class failed
MLGetMatrix and the matrix is larger
than the space available in the worksheet. This error destabilizes the Spreadsheet Link software session and changes worksheet calculation mode to manual.
Click OK. Reset worksheet calculation mode to
automatic, and save your worksheet as needed. Restart the
Excel, Spreadsheet Link, and MATLAB® software sessions.
MATLAB failed to check out a license of
Spreadsheet Link or does not have a valid installation of Spreadsheet
You entered an invalid license pass code or did not install Spreadsheet Link properly.
Ensure that you entered the license pass code properly. Reinstall the
Spreadsheet Link add-on. (See Installation.) If you followed the installation guidelines, used a proper pass code, and you
are still unable to start the Spreadsheet Link software, contact your MathWorks® representative.
Excel; prompt for user name and password
This message appears when an attempt to connect to the Excel software from the Database Toolbox™ software fails.
Ensure that the Excel worksheet referenced by the data source exists, then retry the
Could not load some objects because they are not available on
This message appears when Excel 2013 is not configured properly.
From the Windows
Control Panel, remove Microsoft® Office 2010 in the programs list.
This error appears when you start the automation server from the
Excel interface, and multiple versions of the MATLAB software are installed on your desktop.
To correct this error, ensure that you have administrator privileges on
your machine and then perform the following:
Shut down all MATLAB and Excel instances.
Open a command prompt, and using
cd, change to the
bin\win64 subfolder of the MATLAB installation folder.
When the MATLAB session starts, close it. Using
fixes the registry entries.
Start an Excel session. The Spreadsheet Link add-in now loads properly.
Verify that the Spreadsheet Link software is working by entering the following command from the
Enter the following formula in cell
A1 of the open
3.14159 appears in cell