| Spreadsheet Link™ EX | ![]() |
You may see these error messages displayed in a worksheet cell.
The first column of the following table 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
Worksheet Cell | Meaning | Solution |
|---|---|---|
| #COLS>#MAXCOLS! | Your MATLAB variable exceeds the Microsoft Excel limit of #MAXCOLS! columns. | This is a limitation in the Excel product. Try the computation with a variable containing fewer columns. |
| #COMMAND! | The MATLAB software does not recognize the command in an MLEvalString function. The command may be misspelled. | Verify the spelling of the MATLAB command. Correct typing errors. |
| #DIMENSION! | You used MLAppendMatrix and the dimensions of the appended data do not match the dimensions of the matrix you want to append. | Verify the matrix dimensions and the appended data dimensions, and correct the argument. For more information, see the MLAppendMatrix reference page. |
| #INVALIDNAME! | 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. |
| #INVALIDTYPE! | You have specified an illegal MATLAB data type with MLGetVar or MLGetMatrix. | For a list of supported MATLAB data types, see Classes (Data Types) in the MATLAB Programming Fundamentals documentation. |
| #MATLAB? | You used a Spreadsheet Link EX function and no MATLAB software session is running. | Start the Spreadsheet Link EX and MATLAB software. See Starting and Stopping the Spreadsheet Link EX Software. |
| #NAME? | The function name is unrecognized. The excllink.xla add-in is not loaded, or the function name may be misspelled. | Be sure the excllink.xla add-in is loaded. See Configuring the Spreadsheet Link EX Software. Check the spelling of the function name. Correct typing errors. |
| #NONEXIST! | You referenced a nonexistent matrix in an MLGetMatrix or MLDeleteMatrix function. The matrix name may be misspelled. | Verify the spelling of the MATLAB matrix. Use the MATLAB whos command to display existing matrices. Correct typing errors. |
| #ROWS>#MAXROWS! | Your MATLAB variable exceeds the Excel limit of #MAXROWS! rows. | This is a limitation in the Excel product. Try the computation with a variable containing fewer rows. |
| #SYNTAX? | You entered a Spreadsheet Link EX function with incorrect syntax. For example, you did not specify double quotation marks (") , or you specified single quotation marks (') instead of double quotation marks. | Verify and correct the function syntax. For more information, see Functions — Alphabetical List. |
| #VALUE! | 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 MLGetMatrix followed by MatlabRequest, which is correct standard usage. A macro function calls that subroutine, and you execute that function from a worksheet cell. The function works correctly, but this message appears in the cell. | Since the function works correctly, ignore the message. Or, in this special case, remove MatlabRequest from the subroutine. |
Note When you open an Excel worksheet that contains Spreadsheet Link EX functions, the Excel software tries to execute the functions from the bottom up and right to left. Excel may generate cell error messages such as #COMMAND! or #NONEXIST!. This is expected behavior. Do the following:
|
![]() | Error Messages and Troubleshooting | Microsoft Excel Software Errors | ![]() |
| © 1984-2008- The MathWorks, Inc. - Site Help - Patents - Trademarks - Privacy Policy - Preventing Piracy - RSS |