As a developer and analyst, I heavily rely on the powerful features and flexibility that Microsoft Excel provides for various tasks. This was especially true when I was supporting enterprise level accounting systems. I would often be working with two or more workbooks at a time, and loved having the ability to view two worksheets at the same time using dual monitors.

With the release of Excel 2007/2010, this ability to open two separate instances of Excel is no longer as easy as double-clicking on an Excel Shortcut anymore. Microsoft has forced users to one MDI container for all their Excel windows. As far as I can tell, the primary benefit of being constrained to one MDI container is less memory usage and features specific to DDE. Due to the nature of Excel and the numerous ways people use it, I think Microsoft was smart to make this the default behavior. However, their neglect in making this behavior optional, thereby forcing it on users, is unacceptable.

The popular way to get around this problem is to disable DDE in Excel, allowing you to once again open new windows in separate instances of Excel. Unfortunately, this breaks some essential DDE specific features, such as being able to copy formulas between separate instances of Excel.

Therefore, the best solution (for me) is to make opening a separate instance an option. Instead of double-left-clicking on the spreadsheet files, you will just use right-click and ‘Open in New Window’ whenever you wish to open a document in a completely new Excel instance.

To accomplish this, you will be creating a new Action like ‘Open in New Window’ on your popup action menu (right click), and this action can be set to ignore DDE. This will allow you independently control how Excel opens supported files (XLS, XLSX, CSV, etc).

The easiest way to do implement this is by following the instructions below:

Note: I have only verified that these instructions work on Windows XP and Office 2007/2010. If you try with different software, your results *may* vary.

1.      In Windows Explorer, go to Tools > Folder Options > File Types

2.      Scroll down to the XLS extension and click [Advanced]

3.      Click on “Open” in the list to highlight it and then click [Edit]

4.      Copy [CTRL-C] the Application Path contents to clipboard (or notepad)

  • Example: “C:\Program Files\Microsoft Office\Office14\EXCEL.EXE” /dde

5.      Click [Cancel] button to close the window

6.      Now, click [New] (to create a new Action)

7.      Give the action a name (like ‘Open in &New Window’)

8.      Paste [CTRL-V] the path from clipboard (or notepad)

9.      Now add the following to the end of the path you just pasted: <space>”%1″

  • Example: “C:\Program Files\Microsoft Office\Office14\EXCEL.EXE” /dde “%1”

10.    Verify that “Use DDE” is unchecked

11.    Click [OK] to save changes

12.    Rinse and Repeat (from step 2) for XLSX, XLSM and CSV extensions

DONE!

You should now be able to right-click on an excel file and click on ‘Open in New Window’ (or whatever name you entered for Step 7), and Excel will open that file in a completely new instance.

Finally, as Step 12 implies, if there are other extensions that Excel supports which you would like to open in a separate instance, just repeat steps 2 through 11 for each extension.

I hope you find this regained freedom as beneficial as I have!

Charles Peri is a programmer analyst with 20+ years of programming and database development experience.

11 comments on “How to make Excel open each file in a separate window. Tip #198

  • Thanks very much for the info. But I disagree thet this is a usefull feature for all users. Running multiple documents is an issue for the Taskbar, that sovles this rather nicely. And memory usage is for the operating system. All the nice usability and stability features implemented the are lost to Excel :(

      • Dont work on windows 7 32 bit :( On XP this works as this tutorial say.
        I still not have luck find solution for 7.

        Memory now is no problem a and for taskbar on multimonitor you need 3rd party software like ultramon.

        Wish that MS do much more work on support multimonitor. Is stupid that need still looking on web and installing 3rd party software.

  • Great idea and thanks for sharing! adding an 'open in new window' to the right click menu gives me the option to cleanly do exactly what I wanted. Using excel 2010 in win XP.

  • You have two xls files, open one of them.
    Then go to the 'Start Menu' open a new (blank workbook) from there.
    Go to 'file' on the blank workbook and navigate to the second xls workbook and open it.
    Result, two open seperate workbook windows.
    Excel 2010, Vista

  • Hi Charles Peri,
    Help !  Please send me instructions of how to Un-Do this excel tip #198, I am on Win XP —
    The excel files are too hard to manage now, and I need to un-do this.
    Thanks, with best wishes,  Mike

    •  @Mike Temp Hi Mike,
      Unfortunately I am no longer using XP (using Windows 7 now) to test my following suggestion, however it should be fairly easy to undo what was done in the tutorial:
       
      1.      In Windows Explorer, go to Tools > Folder Options > File Types
      2.      Scroll down to the XLS extension and click [Advanced]
      3.      Click on the action “Open in &New Window” in the list to highlight it and then click [Delete]
      4.    Rinse and Repeat (from step 2) for XLSX, XLSM and CSV extensions
      UN-DONE! :)
       
      This should remove the “Open in &New Window” option that you had added (for each extension you might have added it to) and everything should work like normal again.
       
      Best Wishes,
      Charles Peri

  • It is worth noting that Windows 7 has made this process unnecessary (and apparently VIsta as well from a previous comment). To quickly open a separate Excel window in Windows 7, I do the following:
     
    1. Pin Excel to your task bar (located at the bottom of your screen by default)
    2. Open up a document in Excel
    3. Right-Click on the Excel icon in the task bar
    4. In the pop-up menu, click on  “Microsoft Excel 2010”
     
    DONE! You have just opened a NEW instance of Excel in a SEPERATE window! Now you can navigate to a document (or use your recent files list) using the new window.
     
    Best wishes,
    Charles Peri

    • Or indeed just open the first Excel instance, then to open another Excel instance just shift-click on the task bar icon that the first one put there.

      Works for any application.

Leave a Reply

Your email address will not be published. Required fields are marked *