Main Content

Microsoft Excel Errors

The Excel® software can display these error messages.

Error Message

Cause of Error

Solution

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.

Note

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 library

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 Tools > References to open the References window. Select the box named SpreadsheetLink. Click OK.

Run-time error '1004': Cells method of Application class failed

You used 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 Link

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.

Datasource: 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 properly.

From the Windows Control Panel, remove Microsoft® Office 2010 in the programs list.

Run-time error '429': ActiveX component can't create object

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:

  1. Shut down all MATLAB and Excel instances.

  2. Open a command prompt, and using cd, change to the bin\win64 subfolder of the MATLAB installation folder.

  3. Type the command:

    .\matlab /regserver

  4. When the MATLAB session starts, close it. Using /regserver fixes the registry entries.

  5. Start an Excel session. The Spreadsheet Link add-in now loads properly.

  6. Verify that the Spreadsheet Link software is working by entering the following command from the Command Window:

    a = 3.14159

  7. Enter the following formula in cell A1 of the open Excel worksheet:

    =mlgetmatrix("a","a1")

  8. The value 3.14159 appears in cell A1.