I am running Excel 2007 on Windows 7 64-bit. I need to run Excel as administrator so I have the "Run as Administrator" box in the Excel shortcut checked.
Now, when I try to open an Excel file by double clicking, I get the following error:
There was a problem sending the command to the program
Excel opens fine after that, and I can open the file fine through Excel's File/Open menu.
Why can't I open the file by double clicking? Some sites suggest changing a specific Excel option. I tried while checking/unchecking Excel's "Ignore other applications that use Dynamic Data Exchange (DDE)" but that didn't help. The issue goes away if I uncheck "Run as Administrator" but I want to be able to leave that checked.