MATLAB: Do I experience run-time errors when using Excel Link 2.2 (R14)

arraybasicdefinederrorexcellinkr14runrun timeruntimeSpreadsheet Linktimevisualworkspace

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

Best Answer

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.
Related Question