Why do I experience run-time errors when using Excel Link 2.2 (R14)?

I have installed Excel Link for Microsoft Excel. However, when I invoke Excel, I experience the following Visual Basic popup error message:

 Run-time error '-2147352567 (80020009)':

 Array is not defined in the workspace

Answer 1

[MathWorks Support Team]

This bug has been fixed in Release 14 Service Pack 2 (R14SP2). For previous releases, please read below for any possible workarounds:

We have verified that there is a bug in Excel Link 2.2 (R14) in the way that it handles initialization. To work around this issue, try first invoking MATLAB as a COM automation server, and then invoking Excel. To invoke MATLAB as a COM automation server, open the Run dialog box by selecting Run from the Windows start menu. Then run the following command:

 matlab /Automation

A minimized instance of MATLAB should appear. If you invoke Excel, it should now connect to this instance of MATLAB.

Another way of solving the problem is shown below:

1) Create a shortcut for MATLAB on the desktop.

2) Right click on the shortcut and select "Properties".

3) Type " /automation" after "...\bin\win32\MATLAB.exe" in the box next to Target.

In that case, you do not have to type " matlab /automation" from the Windows start menu. Instead you may start MATLAB in the automation mode using the new shortcut.