Why do I receive a "Run-Time Error 429" when I try to use Spreadsheet Link EX with Excel?

Question

MathWorks Support Team on 14 Jun 2012

1
Link

Direct link to this question

https://www.mathworks.com/matlabcentral/answers/99194-why-do-i-receive-a-run-time-error-429-when-i-try-to-use-spreadsheet-link-ex-with-excel

Accepted Answer: MathWorks Support Team

I have properly installed MATLAB and Spreadsheet Link EX but when I launch Excel I get a runtime error 429.

Sign in to answer this question.

Answer 1

MathWorks Support Team on 14 Nov 2017

0
Link

Direct link to this answer

https://www.mathworks.com/matlabcentral/answers/99194-why-do-i-receive-a-run-time-error-429-when-i-try-to-use-spreadsheet-link-ex-with-excel#answer_108541

This error can occur if the automation server for Excel Link was not registered properly. Reregistering can fix the issue.

You can do this by using the following command at the MATLAB Command Prompt:

!matlab -regserver

Equivalently, you can execute the following in the Windows Command Prompt:

matlab -regserver

If you are using a Windows version that includes User Account Control (e.g. Windows Vista or Windows 7), you may need to start the Command Prompt with elevated privileges. You can right click on the Command Prompt shortcut and choose "Run as Administrator".