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.
space_timeAsked:
Who is Participating?
 
Hello ThereSystem AdministratorCommented:
0
 
Fabrice LambertFabrice LambertCommented:
As a workaround, on W10, hold the shift key while clicking on the excel shortcut on your task bar or desktop, this will open a new instance (thus a new window) of your application.
This might work on W7, I'll let you test.

Curious, why do you need excel documents opened in its own Windows ?
0
 
space_timeAuthor Commented:
Found something that works for me but it isn't the prettiest.

Open regedit, browse to HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open
Delete the ddeexec key
Click on the "command" key and replace /dde on the end with "%1" (quotes included)

so keys should look like this:
(Default) REG_SZ "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.EXE" "%1"
command REG_MULTI_SZ vUpAVX!!!!!!!!!MKKSkEXCELFiles>tW{~$4[=]9==,*)Nn] "%1"

Do the same for Excel.Sheet.12 which is for .xlsx files.

Bit of a pain but if it doesn't cause me problem over next few days will push out reg changes via GPO.
Why does it always seem that a solution presents itself the moment I ask for help.
0
 
Fabrice LambertFabrice LambertCommented:
Why does it always seem that a solution presents itself the moment I ask for help.
Murphy's law :p
0
 
space_timeAuthor Commented:
Would like to leave this open to see if anyone else has a different solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.