Error in formula
You entered a formula incorrectly. Common errors include
a space between the function name and the left parenthesis; or missing,
extra, or mismatched parentheses.
If you use the Spreadsheet
Link™ software with a non-English
United States) 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
Sub or Function not defined
You executed a macro and the location of
incorrect or not specified.
Click OK. The References window
opens. Remove the check mark from
excllink.xla 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
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
automatic, and save your worksheet as needed.
Restart the Excel, Spreadsheet
Link, and MATLAB® software
MATLAB failed to check
out a license of Spreadsheet Link or does not have a valid installation
of Spreadsheet Link
You entered an invalid license pass code or did not install Spreadsheet
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 connection.
Could not load some objects because they are
not available on this machine
This message appears when Excel 2013 is not configured
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