Results 1 to 7 of 7
  1. #1
    New Lounger
    Join Date
    Jul 2004
    Location
    Minneapolis, Minnesota, USA
    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Opening multiple Excel windows - Excel 2010, Windows 7

    I do a lot of copying data or looking it up with multiple workbooks open at the same time.
    I generally open them by double clicking them in a directory in file explorer.

    The default for this is to open all the workbooks in one window which covers each one up with the others or forces them to be small.

    I want to open them where they are in separate Excel windows. I have found a work around by open separate instances of excel then opening the files from file explorer but it doesn't always work well and is clunky at best.

    We found a description of a method at http://www.coretekservices.com/2011/...parate-windows but it didn't work on my computer.

    Bill

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    Try this:
    File - Options - Advanced, scroll down to near the bottom and check the option to 'Ignore other applications that use Dynamic Data Exchange (DDE)'.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    New Lounger
    Join Date
    Jul 2004
    Location
    Minneapolis, Minnesota, USA
    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts
    That didn't work. I got one new window the first time I tried it. After that, I get this error message every time I try to open any file by double clicking.
    Capture.PNG

    I do have a Personal.XLSB book to hold global macros. I get an error saying that it cannot be opened because I have it open for editing, even when I have all copies of excel closed.

  4. #4
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    ..what about opening your multiple instances, then 'dragging the file from the explorer window' onto the instance.

    (..you are going to like Excel2013/Excel2016 which opens everything in a separate window)

    zeddy

  5. The Following User Says Thank You to zeddy For This Useful Post:

    bill f (2015-10-14)

  6. #5
    New Lounger
    Join Date
    Jul 2004
    Location
    Minneapolis, Minnesota, USA
    Posts
    16
    Thanks
    2
    Thanked 0 Times in 0 Posts
    Thanks zeddy

    I copied a shortcut from the start menu to the desktop to make it easier to open multiple Excel windows.
    Dragging from the directories worked.

    Still a little bit clunky because of manually opening up the windows and ending up with a bunch of extra workbooks to close (each window creates an empty book).

    However *********** IT WORKS *************

  7. #6
    WS Lounge VIP
    Join Date
    Mar 2002
    Location
    Newcazzle, UK
    Posts
    2,829
    Thanks
    136
    Thanked 482 Times in 459 Posts
    Hi bill

    ..you could add Excel to the bottom windows taskbar, then, for each instance of Excel you want, keep your finger on the [Shift] key as you 'click' the Excel icon on the taskbar for each additional 'instance'. This saves you minimising stuff while you look for the 'shortcut' on the desktop.

    (To add to the taskbar: right-click on Excel in your start menu, and select 'pin to taskbar')

    zeddy

  8. #7
    Lounger akjudge's Avatar
    Join Date
    Jan 2014
    Posts
    41
    Thanks
    1
    Thanked 8 Times in 7 Posts
    I don't know if this will help you, but it made opening multiple workbooks, and copying between them much easier. It is a cheap addon that places each workbook in a tab in one instance of Excel (or Word):

    http://www.extendoffice.com/product/office-tab.html

    I think it has a 30 day free trial...

    Jim

Tags for this Thread

Posting Permissions

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