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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Hello ThereSystem AdministratorCommented:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.