• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 364
  • Last Modified:

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!
0
jamesmetcalf74
Asked:
jamesmetcalf74
  • 2
  • 2
  • 2
  • +1
1 Solution
 
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
 
LazarusCommented:
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
 
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
Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

 
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.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Office 2010

This course will introduce you to the interfaces and features of Microsoft Office 2010 Word, Excel, PowerPoint, Outlook, and Access. You will learn about the features that are shared between all products in the Office suite, as well as the new features that are product specific.

  • 2
  • 2
  • 2
  • +1
Tackle projects and never again get stuck behind a technical roadblock.
Join Now