excel open in multiple windows

This problem is driving me crazy.  I have tried about 5 different fixes and nothing is working from the web.  this is the reason i pay for experts exchange.

my vip user does not like the fact that excel opens in the same window when he clicks on a new xlsx file. he wants it to start a new session of excel so he can look at the two spreadsheets at the same time.  
windows 7 64 bit
office excel 2010

help!
jamesmetcalf74Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
LazarusConnect With a Mentor Commented:
To resolve this, go to 'excel options' > click on the 'advanced' tab > scroll down to general > check the ignore other applications that use 'Dynamic Data Exchange (DDE)'

That was for Excel 2007, Not sure if that still works for 2010

I have found this link though to a Registry fix for it in 2010:
http://www.conetrix.com/Blog/post/How-to-Open-Each-Excel-Spreadsheet-in-a-New-Instance.aspx

This is also another way:
http://ptihosting.com/blog/it-blog/force-excel-20072010-to-open-in-seperate-window/
0
 
jamesmetcalf74Author Commented:
oh and i know you can start excel over and over again and open teh file to accomplish this.
i need it to be automatic
0
 
GeisrudSystems AdministratorCommented:
Press and hold the Shift key, then click the Excel icon on your task bar and it will open a new instance of Excel in a separate window.
0
The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

 
mark_harris231Commented:
See the following prior solution for a method that adds right-click functionality.  Using this method, you can set Excel to open a new instance by default with right-click to open in the same instance, or the reverse - open in the same instance by default and right-click to open in a new instance.

Excel Multiple Instances
0
 
LazarusCommented:
@ mark_harris231, he wants to have this done automatically. That was addressed previously in my earlier response in a link, as well the adding the right click choice was also addressed.
0
 
mark_harris231Commented:
@lazarus98 - my mistake.  I saw your lead with the DDE and didn't read further to see you referenced essentially the same registry fix.

I did see that the request was for automatic, but thought it was relevant to identify that right-click menu functionality was also an option.  Personally, I have my system set up to open in the same workbook by default, but with right-click for new instance.

FYI - The DDE suggestion does not work in Excel 2010.  It will cause Excel to be unable to open valid files by double-click (although they can still be opened from the File menu).
0
 
jamesmetcalf74Author Commented:
thanks!
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.