Probably something that anyone who uses Excel has asked. When I open an Excel file (double-clicking on the file) how can it be made to open in its own window?
I made the change in OPTIONS > ADVANCED > GENERAL > (ticked) IGNORE OTHER APPLICATIONS THAT USE DDE.
When I open the file after doing this it opens a new window but I get the message: "THERE WAS A PROBLEM SENDING THE COMMAND TO THE PROGRAM" and the file doesn't open.
Google says the solution to the latter problem is to undo the former change.
At the moment the workaround (because it feels like more steps than should be necessary) is to open a new Excel window manually and drag the desired file in to be opened or opened via the file menu etc. I am sure I have got this working in the past but do not recall the trick to it. I have also seen all the reg hacks and stuff but I am sceptical about it being so complicated.
Excel 2010 (64 bit) on Windows 7 (64 bit). All software is patched and up to date. Please help.