Why does "An error occurred when sending commands to the program" appear when opening Excel 2010 files? (Easy Fix Article)

Article translations Article translations
Article ID: 2616247 - View products that this article applies to.
Expand all | Collapse all

Scenario Description

It's kinda weird, why does the "User Account Control" window appear everytime when I open Excel 2010 files, along with the error message "An error occurred when sending commands to the program" after pressing "Yes"? The Excel contents are greyed out, making it impossible to open files properly. How can I solve this problem?


Collapse this imageExpand this image
2748874



Simple solutions 123

First, click the "Start" button and then click "Computer".


Collapse this imageExpand this image
2748875



Next, locate the following folder X:\Program Files\Microsoft Office\Office14. The Drive C is used as an example here.


Collapse this imageExpand this image
2748876



Collapse this tableExpand this table
Collapse this imageExpand this image
KBTip male

Hint:
If the folder is not in Drive C, change X to the drive letter where the [Program Files] folder is located.


Right-click EXCEL and click [Properties].


Collapse this imageExpand this image
2748877



And then, click [Compatibility] and uncheck [Run as system administrator].


Collapse this imageExpand this image
2748878



Open Excel 2011, click [File], and click [Options].


Collapse this imageExpand this image
2748881



Click [Advanced], uncheck [Ignore other applications that use Dynamic Data Exchange (DDE)], click [OK], and then close Excel 2010.


Collapse this imageExpand this image
2748882



The next time you open any Excel file, no error message should appear and the file can be opened properly.


Collapse this imageExpand this image
2748883



If this still does not work, proceed with the following steps. Click [File] and then click [Options].


Collapse this imageExpand this image
2748884



Click [Add-in], select [COM add-in] from the [Management] option, and then click [Run].


Collapse this imageExpand this image
2748894



Uncheck all the Add-ins and then click [OK] to see if the problem has been solved. If it has, find out which add-in caused this issue through process of elimination, and then remove that particular add-in.


Collapse this imageExpand this image
2748895



If the same problem persists, please refer to the articles in below "Other relevant information".

Other relevant information

Please let us know

Collapse this tableExpand this table
Collapse this imageExpand this image
Please let us know
Are you satisfied with our contents? Whether you think:
"Great! Problems solved."」
or "Problems are not solved. I have a better idea."」
we would like you to provide us with your precious opinions using the survey form located at the bottom of this article. We welcome any encouragements you may have, and will be creating more useful technical articles for you.
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See Terms of Use for other considerations.

Properties

Article ID: 2616247 - Last Review: May 29, 2014 - Revision: 2.3
Applies to
  • Microsoft Excel 2010
Keywords: 
kbprb kbtshoot kbexpertisebeginner kbstepbystep kbgraphxlink KB2616247

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com