You might see these error messages displayed in a worksheet cell.
The first column contains worksheet cell error messages. The
error messages begin with the number sign (
Most end with an exclamation point (
!) or with
a question mark (
Worksheet Cell Error Messages
Your MATLAB® variable exceeds the Microsoft®
This is a limitation in the Excel product. Try the computation with a variable containing fewer columns.
The MATLAB software does not recognize the command
Verify the spelling of the MATLAB command. Correct typing errors.
Verify the matrix dimensions and the appended data dimensions,
and correct the argument. For more information, see the
You entered an illegal variable name.
Make sure to use legal MATLAB variable names. MATLAB variable names must start with a letter followed by up to 30 letters, digits, or underscores.
Make sure to use the supported MATLAB data types.
You used a Spreadsheet Link™ function and no MATLAB software session is running.
Start the Spreadsheet Link and MATLAB software. See Start and Stop Spreadsheet Link and MATLAB.
The function name is unrecognized. The
Be sure the
Also, you receive
Verify the spelling of the MATLAB matrix. Use the MATLAB
Your MATLAB variable exceeds the Excel limit
This is a limitation in the Excel product. Try the computation with a variable containing fewer rows.
You entered a Spreadsheet
Link function with incorrect
syntax. For example, you did not specify double quotation marks
Verify and correct the function syntax.
An argument is missing from a function, or a function argument is the wrong type.
Supply the correct number of function arguments, of the correct type.
A macro subroutine uses
Since the function works correctly, ignore the message.
Or, in this special case, remove
|The named range is defined incorrectly, or the named range spans multiple worksheets.||Select a range of data on only one worksheet and create an appropriate name for the range of data. For instructions about defining names, see Excel Help.|
When you open an Excel worksheet that contains Spreadsheet
the Excel software tries to execute the functions from the bottom
up and right to left. Excel might generate cell error messages
This is expected behavior, so ignore the messages and do the following:
Close the MATLAB figure windows.
Execute the cell functions again one at a time in the correct order by pressing F2, and then Enter.