Pages

Friday, May 6, 2011

How to open each file in new window in Excel 2010

 

Overview

You are using Excel 2010 (May for for Excel 2007 as well). You want to open each file in Excel as separate window. By default Excel 2010 (and Excel 2007) opens each file within the Excel Program. Excel 2010 and 2007 are designed as MDI applications.

Disclaimer

This is not Microsoft supported option. Although this has worked well for me, use caution as this approach includes on undocumented registry changes suggested by many other internet search results. It was confusing to try out all the options and get the result correct.  I wanted to share clearly given my situation what has worked.

Other Considerations

Being able to open each file in new window means being able to run new instance of Excel.exe program, that means you are using more memory. So use caution while trying to open more files when you have your excel program configured for this situation.

My Platform

  • Windows 7 x64 Ultimate (I Guess any editions might result with same behavior)

  • Office Professional Plus 2010 (I Guess any editions might result with same behavior)

    My Settings

    To make .xlsx file open in new window.

  • Open registering editing tool.

  • Navigate to “HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open”

  • Right click on “Open” note and and export to file to save as backup.

  • Go to “Command” node.

  • Update the “Default” key to below value

    "C:\Program Files\Microsoft Office\Office14\EXCEL.EXE" /e "%1"


  • Rename the “Command” key below the “Default” key to “CommandOld”

  • Rename the “ddeexec”  Node to “ddeexecOld”

    You should see your registry changes similar to below pictures after change has been made:

    image

    image

    Now give it shot by open the “.xlsx”  files, you will see each file is opened in new window.

    Beware each Excel.xxxx  registry key is for each type of file that Excel as association with.

    For other type of extension based files fine below nodes and based on that I guess you can figure out your other type of files that you want to open to be configured the same.

    File Type to Open Registry sub key File Version
    For .xlsx Excel.sheet.12 Excel 2010 file
    For .xls Excel.sheet.8 Excel 2003-2007 file
    For .csv Excel.CSV Comma separated file

    Happy Excelling with more windows!

    Technorati Tags:
  • 17 comments:

    Mike McCloskey said...

    Worked like a charm for .xls and .xlsx files. Thanks!!

    Mike McCloskey said...

    Worked like a charm for .xls and .xlsx files. Thanks!!

    Anonymous said...

    this is the best tip I have found.
    it works and works well. thanks

    Taavi said...

    Thanks dude
    The instructions were short but very clear and saved my day :)

    Taavi said...

    Thanks dude
    The instructions were short but very clear and saved my day :)

    Tim said...

    Awesome, thanks!

    Mark said...

    I just spent a half an hour trying to find a solution to this. Works like a charm. Thanks!

    Steen Martiny said...

    Works as described in terms of opening Excel-files in independent windows. Fast enough, but only on first Excel file. On second file a search for content starts and only after finishing this Excel opens the xlsx-file.

    And yes: I have removed all indexing in CP>Folder Options and no checkmark in Explorer>Folder Options>Always Search. Windows 8 Pro x64 build 9200 used.

    Any ideas on how to removed this unexpected side-effect?

    Steen Martiny said...

    Works as described in terms of opening Excel-files in independent windows. Fast enough, but only on first Excel file. On second file a search for content starts and only after finishing this Excel opens the xlsx-file.

    And yes: I have removed all indexing in CP>Folder Options and no checkmark in Explorer>Folder Options>Always Search. Windows 8 Pro x64 build 9200 used.

    Any ideas on how to removed this unexpected side-effect?

    Mahobin said...

    It works! Thanks so much, Rajesh.

    Anonymous said...

    Great.. worked perfect for me..

    Thanks buddy

    Matt said...

    Works perfectly, Thank You!! solves this pesky little Excel quirk!

    Derek said...

    Thanks for finding a fix for this.

    Why in the world micrsoft removed this option is beyond me.

    Anonymous said...

    Works Like a charm also one more thing I had to do was add remove programs and click on Excel and and sat run all from my computer Thank you so much..!!

    Anonymous said...

    Thank you for the good writeup. It in fact was a amusement account it.
    Look advanced to far added agreeable from you!

    However, how can we communicate?

    my webpage: how to open csv file in Excel

    Hartley said...

    Perfect. Easy. Thank you.

    Anonymous said...

    An alternative method is to create a shortcut of EXCEL.EXE on your desktop. To open an Excel document in another instance just drag and drop onto the shortcut you created on the desktop.