+ Reply to Thread
Results 1 to 9 of 9

Opening Seperate Excel Instances with Windows 7

  1. #1
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Opening Seperate Excel Instances with Windows 7

    Since having upgraded to Windows 7, I can no longer open a new/seperate Excel instance to compare files, without having to open a new instance from the Excel Icon on my desktop and then opening a saved file using the "Open" feature within Excel.

    For Example; I have two Excel attachments from an email that I would like to open in seperate Excel instances to compare data. If I have 2 seperate Excel instances open (using the Excel icon from my desktop both times), and try to open one of the two files it would open in the first instance Opened. Then if I click on the 2nd instance I opened earlier to make it active and try to open the 2nd file it will open in the first instance rather than the 2nd one I last made active.

    So currently as my work around I have to doucle click or right click to open one Excel file which would open a brand new Excel instance (given that there are none already open). Then to open the 2nd Excel file I would have to save a copy on my computer > open a new instance using the Excel icon on my desktop > and go file Open to open the file.

    Question: Is there any way I can have it where a new file will always open in a new instance?

  2. #2
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Opening Seperate Excel Instances with Windows 7

    Why do you need separate instances of Excel in order to compare two files?

    You can open both in one instance of Excel and then use View | Arrange All | Tiled to see the two files side by side.

    Also see:

    http://dottech.org/26491/how-to-forc...-how-to-guide/

    Regards, TMS
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke


  3. #3
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Opening Seperate Excel Instances with Windows 7

    This is for work and I have dual monitors and need to compare large amounts of data at a time.

  4. #4
    Forum Contributor
    Join Date
    03-05-2009
    Location
    usa
    MS-Off Ver
    Excel 2016 32Bit
    Posts
    1,173

    Re: Opening Seperate Excel Instances with Windows 7

    When I use two monitors I do this
    open first excel file and move to other monitor
    then go to programs and open excel then other file

  5. #5
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Opening Seperate Excel Instances with Windows 7

    Is there any way I can have it where a new file will always open in a new instance?
    Excel Options > Advanced > General, tick Ignore other applications that use DDE
    Entia non sunt multiplicanda sine necessitate

  6. #6
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Opening Seperate Excel Instances with Windows 7

    With dual monitors, open Excel and use the restore down icon to reduce the size of the Excel Window. Now drag the border across the second monitor. Stretch the borders, top, bottom and sides, to fill both monitors.

    Open both files, then View | Arrange all | Tile. Provided, you just have two files open, you'll see one in each monitor.

    Regards, TMS

  7. #7
    Registered User
    Join Date
    09-20-2012
    Location
    Jacksonville, FL
    MS-Off Ver
    Excel 2007
    Posts
    80

    Re: Opening Seperate Excel Instances with Windows 7

    Great, thanks

  8. #8
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Opening Seperate Excel Instances with Windows 7

    You're welcome.


    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.

  9. #9
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,420

    Re: Opening Seperate Excel Instances with Windows 7

    Thanks for the rep

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1