Excel Error: There was a problem sending the command to the program

Excel Error: There was a problem sending the command to the program

15 August 2012

If you click on an excel file and get this error instead of Excel opening your document and you have followed the MS link to disable the DDE apps already but it is still failing then you probably are victim of a Windows Update issue.

On 15th August it would appear that Office was security patched and if you have Power Pivot installed as an Excel Add-in then you get this error whilst it loads power pivot.

Security Update for Microsoft Office 2007 suites
A security vulnerability exists in Microsoft Office 2007 suites that could allow arbitrary code to run when a maliciously modified file is opened. This update resolves that vulnerability. http://support.microsoft.com/kb/2596856)

I don’t know what the solution is to this yet so its probably just a case of waiting for MS to issue another patch but in the meantime, if you can, disable the Power Pivot Add-in and Excel will load documents properly again.

open Excel – Goto File – Options – Add-ins – at the bottom choose to manage COM add-ins and go – Uncheck the Power Pivot Add-in in dialog and click OK

If, like me, you are a Business Intelligence developer and need Power Pivot then you will not be too happy about this so please urge MS to supply a fix soon. You can re-enable the plugin as and when you need it though until this is fixed.

Hope this helps someone

Dave
Excel will now start super fastbut you cannot use the power pivot.

Knowledgebase artice referenced above = http://support.microsoft.com/kb/211494

Advertisements

About davidbridge

I am a contractor for David Bridge Technology Limited specialising in database design and Web development using Microsoft technologies such as c#, MVC .net and SQL Server (full stack)
This entry was posted in Developer stuff, Other stuff, SQL Stuff and tagged , , , , , , , . Bookmark the permalink.

One Response to Excel Error: There was a problem sending the command to the program

  1. Good write-up. I certainly appreciate this website.
    Thanks!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s