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
My Settings
To make .xlsx file open in new window.
"C:\Program Files\Microsoft Office\Office14\EXCEL.EXE" /e "%1"
You should see your registry changes similar to below pictures after change has been made:
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!
Posts
17 comments:
Worked like a charm for .xls and .xlsx files. Thanks!!
Worked like a charm for .xls and .xlsx files. Thanks!!
this is the best tip I have found.
it works and works well. thanks
Thanks dude
The instructions were short but very clear and saved my day :)
Thanks dude
The instructions were short but very clear and saved my day :)
Awesome, thanks!
I just spent a half an hour trying to find a solution to this. Works like a charm. Thanks!
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?
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?
It works! Thanks so much, Rajesh.
Great.. worked perfect for me..
Thanks buddy
Works perfectly, Thank You!! solves this pesky little Excel quirk!
Thanks for finding a fix for this.
Why in the world micrsoft removed this option is beyond me.
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..!!
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
Perfect. Easy. Thank you.
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.
Post a Comment