Open Excel file in a new window
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.
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.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Why does it always seem that a solution presents itself the moment I ask for help.Murphy's law :p
ASKER
Would like to leave this open to see if anyone else has a different solution.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This might work on W7, I'll let you test.
Curious, why do you need excel documents opened in its own Windows ?