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.

Check entry and correct typing errors.

Can't find project or library

You tried to execute a macro and the location of excllink.xla is incorrect.

Click OK. The References window opens. Remove the check from MISSING: excllink.xla. Find excllink.xla in its correct location, select its check box in the References window, and 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 EX 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 EX, and MATLAB software sessions.

Spreadsheet Link EX license checkout failed!

The license passcode that you entered was invalid.

Check that you entered the license passcode properly. If you used a proper passcode and you are still unable to start the Spreadsheet Link EX 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.

Make sure that the Excel spreadsheet referenced by the data source exists, then retry the connection.

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, perform the following:

1. Shut down all MATLAB and Excel instances.

2. Open a Command Prompt window, and using cd, change to the bin\win32 subdirectory of the MATLAB installation directory.

3. Type the command:

   .\matlab /regserver

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

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

6. Verify that the Spreadsheet Link EX software is working by entering the following command from the MATLAB 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.