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
Excel will now start super fastbut you cannot use the power pivot.
Knowledgebase artice referenced above = http://support.microsoft.com/kb/211494