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
* Microsoft Excel 2010 – Version: 14.0.6112.5000 (32-Bit) *
* Windows 7 Enterprise (SP1) *
Thank you, this was very helpful as I was also seeing the, "There was a problem sending the command to the program" error, when I would try to open any Excel files. However, I had the "Ignore other applications that use Dynamic Data Exchange (DDE)" option
turned "ON"/checked. So, when I turned it off/unchecked it, I stopped having this problem! However, this posting says:
"I had turned ON the advanced option:
(File/Options -> Advanced -> General ->)
Ignore other applications that use Dynamic Data Exchange (DDE)"
and then continues on to say:
"Finally I turned
Ignore other applications that use Dynamic Data Exchange (DDE)
back ON"
So, since you had turned it "ON", did you mean to say back "OFF" here? ã
Either way, thank you for helping me resolve this!!
Jeff