Excel 2010 "There was a Problem sending the command to the program" Error

Anonymous
2011-01-28T07:40:23+00:00

Howdy.  After spending hours and hours online looking for a fix - trying the fixes offered time and time again, repairing with the disk, I am still not having any success fixing this error message.

Issue: Just installed Micro Office 2010 on my Windows 7 Ultimate 64-bit.  As a faculty member I had purchased the single license version of Professional from my school (shouldn't be an issue).  All other Micro Office programs seems to be functioning properly.  However, Excel will only open files from within the program - I cannot click the files and open them.  Even if I save a new file that I create - I still cannot open it from outside.

Yes, I have checked that the Ignore Programs option is unchecked.

Yes, I am not running any add-ins.

Please help.  Am at wits' end :(

**Post moved by the moderator to the right forum category.**

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments
Answer accepted by question author
Anonymous
2011-01-28T19:14:28+00:00

Try the following steps:

Right click on Excel (.exe) > Properties > Compatibility > uncheck all the boxes

To access Excel (.exe), open the following location:

Windows 7 32bit: C:\Program Files\Microsoft Office\Office14

Windows 7 64bit: C:\Program Files(x86)\Microsoft Office\Office14

Was this answer helpful?

100+ people found this answer helpful.
0 comments No comments
Answer accepted by question author
Anonymous
2011-07-24T21:23:12+00:00

I have just got rid of the problem.

i've got MS-Excel 64 bit.

I had turned ON the advanced option:

(File/Options -> Advanced ->  General ->)

Ignore other applications that use Dynamic Data Exchange (DDE)

I did that to get rid of the

cannot use object linking and embedding

error when starting Excel.

I consequently found that the problem with this error was that something had changed the DCOM User to my account instead of the launching User

(Component services\Computers\Mycomputer\DComConfig\Microsoft Excel Application-> Properties (right click) -> Identity (tab) change this user to the launching user)

When I did that cannot use object linking and embedding  was gone, but

There was a Problem sending the command to the program

was shown up each time I tried to double click an Excel file.

Finally I turned

Ignore other applications that use Dynamic Data Exchange (DDE)

back ON

and now everything seems to be fine!

Hope that helps

Was this answer helpful?

50+ people found this answer helpful.
0 comments No comments

65 additional answers

Sort by: Newest
  1. Anonymous
    2017-06-27T10:20:05+00:00

    Nice Solved my problem instantly 

    Thanks

    Was this answer helpful?

    0 comments No comments
  2. Anonymous
    2016-04-22T16:27:28+00:00

    Just FYI on issues even when the "Ignore other applications that use Dynamic Data Exchange (DDE)" is unchecked.

    Checkbox "run as administrator" in the compatibility tab of the shortcut for excel or on the excel.exe:

    A) DDE (Dynamic Data Exchange) only functions when "run as administrator" is ON. DDE  is seen as a poor security process. 

    B) "Auto double -click open file" only functions when "run as administrator" is OFF. 

    Notes:

    If the check-box "run as administrator" in the compatibility tab of the shortcut for excel or on the excel.exe then you cannot double click excel files and have them auto-open. You will get a message box "There was a problem sending the command to the program."

    Programs ran as an administrator in windows 7 have stronger security that keeps it safer than earlier OSs because they have found administrators can do more to 'break you machine'.  This why we have the UAC prompts now when asking to open a program as administrator.

    To wrap this up:

    I continually use DDE in the automation field and continually have to check and un-check the "run as administrator" check-box when needing to use DDE. 

    Other programs running as services (same type situation) are no longer accessible from the windows session you are working in since windows 7. Many now have client applications that open in the user session and communicate to the service through secure channels. Even some of those clients now employ encryption for that link just like logging into a web page. Some even have created that client as a webpage.  

    There may be a way to have it all at the same time although I have not pursued it.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2016-01-21T14:07:30+00:00

    you are a myth I solved

    Was this answer helpful?

    0 comments No comments