How to force Microsoft Excel to open files in new window [How-To Guide]

Often times you may find yourself in a position where you are using two or more Excel spreadsheets at the same time. You can, of course, use Alt + Tab to continually switch between the spreadsheets, or use Microsoft’s build-in secondary window function (you know, how you can minimize spreadsheets within the same window) to place the spreadsheets side by side. However neither of these methods is very attractive if you use multiple monitors or if you like using window-resizer programs like WinSplit Revolution. Rather, a best practice when working with multiple Excel spreadsheets at a time is to open the spreadsheets in separate windows, allowing you to easily tile the windows next to each other using WinSplit Revolution or, if you use multiple monitors, allowing you to place each window in its own monitor.

Unfortunately, the default behavior of Microsoft Excel is to open spreadsheets in the same window. Fortunately, there is a way to force Excel to open spreadsheets in new windows. This guide shows you how to do exactly that.

How to force Microsoft Excel to open files in new window

To force Microsoft Excel to open files in new window, you must do a registry tweak. This tweak takes less than five minutes, works on any computer (Windows XP, Vista, Win7, etc.) with Microsoft Office 2003 and higher (e.g. Office 2007, 2010, etc.), and is very easy to do; plus I have provided screenshots to help you, so don’t be scared that you have to modify the registry to do this. Take note, however, a) You need administrator access to your computer otherwise you won’t be able to modify the registry and b) You should be very careful when you have the registry editor open — accidental changes could crash your computer.

This tweak works with all Excel files, including files you open yourself and files that programs open via Excel.

To make Excel open spreadsheets in new windows, do the following:

  • Close Excel, if it is open.
  • Press Win + R on your keyboard, type regedit.exe in the Run box that pops up, and hit OK:

  • Once you hit OK the registry editor will open. Navigate to the HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder:

  • From the HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder right-click on the (Default) registry entry and select Modify…:

  • Add a “%1” to the end of the Value data textbox:

Make sure you include the quotes and make sure you have a space between the /e and the “%1”. Do not modify anything else. Click OK when you have finished.

  • Now right-click the command registry entry (this is from the same HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder), select Rename, and rename it to command2:

Ensure you rename the command registry entry and not the command folder.

  • Next right-click the ddeexec folder (HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec), select Rename, and rename it to ddeexec2:

  • Now go to the Excel.Sheet.8 folder (HKEY_CLASSES_ROOT/Excel.Sheet.8) and repeat the same steps as mentioned above. In other words, add a “%1” to the (Default) registry entry from HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command, rename the command registry entry to command2 from HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command, and rename the ddeexec folder (HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec) to ddeexec2:

  • Close the registry editor (click the X button).
  • Done.

Keep in mind, if you ever update Microsoft Office or apply a patch, you will need to repeat these steps because updates override the registry changes you just made.


I really hope Microsoft adds an option within Excel in future versions to open files in new windows; but until they do, this registry tweak allows you to easily and quickly force Excel to open all files in new windows. Enjoy.

Related Posts


Leave a Reply

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



    You’ll probably think I’m crazy, but is there an inverse to this solution? Excel 2016 forces each instance into its own window and I want to go backwards to the way Excel 2010 had it where a single window/instance could have multiple files open inside…
    I work with dual monitors and my ability to cycle through them is much smoother in a single instance and provides my style of use with much more window control.

  2. Lem Gooding

    Are you sure you are clicking on the > symbol beside the Shell folder, this will expand the folder and show you 7 sub-folders beneath it, one being the “Open folder” where you need to modify the registry?

  3. Lem Gooding

    Thank you for the detailed steps, no issues incorporating the modification, and now I am able to open and run two previously saved files Simultaneously, without having to open a second excel file and pasting one of the two saved excel files into a blank worksheet as I have done in the past as a work around plan for using two independent spreadsheets.

  4. kiquenet kiquenet

    For me, I have not shell/open/command,


    “Content Type”=”application/vnd.openxmlformats-officedocument.spreadsheetml.sheet”


    “FileName”=”C:\Program Files\Microsoft Office 15\Root\VFS\Windows\ShellNew\excel12.xlsx”






    “xlsx”=”C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE”
    “xls”=”C:\Program Files\Microsoft Office 15\Root\Office15\EXCEL.EXE”
    … OMITTED…




  5. kelpiejethro

    Hello, All I’ve seen for solving this problem in google searches is registry hacks. There must be another permanent way of doing this because I have multiple computers that do NOT have this registry hack and double clicking spreadsheet files in explorer or as outlook attachments open them in all seperate windows. Someone out there must know this answer.

  6. Denise Peck

    Looks like I may have done this at one point because I already have both command & command2 and ddeexec & ddeexec2 folders in both Excel.Sheet.12 and Excel.Sheet.8. On both of these the Default has /dde at the end instead of /e but I went ahead & added “%1” to the end after the /dde in both .12 & .8 – is it safe to remove the command & ddeexec (without the 2)? Or should I delete the existing command2 & ddeexec2 folders and rename the current command & ddeexec folders? I’m on Excel 2010 on a Windows 7 machine & really really getting tired of having to right click the icon & navigating to the file I want open in a separate secession of excel.

  7. igogolf

    Search your registry for “EXCELFiles>” you should find many duplicates of the “command” folder and the “ddeexec” folders buried in an “openWithList” folder . Copypasta from there.

  8. Nowhere Man

    I deleted the entire “command” and “ddeexec” folders in the Excel.Sheet.12 and Excel.Sheet.8. Does anyone, please, please, please, know how to bring ’em back? Or does anyone has the complete name to redo/rewrite them again?

  9. Md. Atiqul Islam

    Thank you very much. I faced the problem today morning and my excel files were opening on the same window and I was unable to work opening two windows side by side. After following the steps I found it works. But It is not working in my another pc running os Win XP and office 2007.

  10. Kalispell

    This worked exactly once. Then, the next time – 6 weeks later – I wanted to work in 2 Excel files in separate windows, it didn’t work. They both opened in the same window. The registry edits are still there, they just no longer work. Back to Square One. Not a permanent solution.

  11. DerRudy

    (wrong email in previous comment)

    Desktop View

    Step 1
    Open your first instance of Excel, and then right-click the Excel icon on the Desktop taskbar.
    Step 2
    Hold down the “Alt” key and select “Excel 2013” from the pop-up menu.

  12. DerRudy

    I saw this worked fine:
    Desktop View

    Step 1
    Open your first instance of Excel, and then right-click the Excel icon on the Desktop taskbar.
    Step 2
    Hold down the “Alt” key and select “Excel 2013” from the pop-up menu.


    After doing this tweak, now I can have two spreadsheets in separate monitors but it became harder to use vlookup function as each spreadsheet works on its own…do you have solution to this as well?

  14. Jan Selvig

    I use Excel 2010. When I have an instance of Excel open, it shows up on the taskbar. Right-clicking that instance on the taskbar gives me 3 choices, and one choice is “Microsoft Excel 2010”. left-clicking that option opens a new empty instance of Excel, after which any workbook, including “recent” ones, can be opened in that new instance. The DDE setting mentioned in many proposed solutions doesn’t matter.

  15. Ben

    after having to repeatedly do this on 40 computers after office updates I wrote batch file to make the process quicker.

    reg delete HKCR\Excel.Sheet.12\shell\Open\ddeexec /f

    reg delete HKCR\Excel.Sheet.12\shell\Open\command /v command /f

    reg add HKCR\Excel.Sheet.12\shell\Open\command /ve /t REG_SZ /d “\”C:\Program Files (x86)\Microsft Office\Office14\EXCEL.EXE\” /dde \”%%1\” ” /f

    reg delete HKCR\Excel.Sheet.8\shell\Open\ddeexec /f

    reg delete HKCR\Excel.Sheet.8\shell\Open\command /v command /f

    reg add HKCR\Excel.Sheet.8\shell\Open\command /ve /t REG_SZ /d “\”C:\Program Files (x86)\Microsft Office\Office14\EXCEL.EXE\” /dde \”%%1\” ” /f

  16. Chris

    Thanks very much, this is very annoying and obviously a feature thought up by someone who doesn’t actually use the product. Seems like they’ve run out of ideas and now just creating features on a whim with no user research.

  17. Brian

    Excellent, That is a lot easier than opening another instance of Excel and then finding the file I want to open. Now if you had a way to import a .txt file with a right click/Open WIth…that would be cool.

  18. Shlomo

    Would it be possible for you to tell me if you have a step by step on how to install CWM on a Galaxy 2 i9100? I’m not a tech. person, and I get stuck when I receive a window in which it states that my galaxy has no app with which to open CWM. Thanks in advance, SE

  19. Jtas

    Please help! the fix is working like a charm indeed! but now whenever my outlook has to open or attach excel file, it comes to “Not responding” or just hangs or reboots itself…. any other tweaks that I can solve this problem? I saved time from the wonderful tweak and now losing time on outlook…:(
    thank you!

  20. Jeff

    This fix did not work for me. I’m running Excel 2010 and the only difference that I can see is that my registry has the /dde instead of /e at the end.

    “C:\Program Files(X86)\Microsoft Office\Office14\EXCEL.EXE” /dde “%1”.

    I’ve tried changing the “/dde” to “/e”, but that didn’t work either. Is there anything else I can try?

  21. Riccardo

    Solution works and now any double click opens a different Excel window (OK).
    Remaining problem: a VBA macro cannot see workbooks in other window.
    In other pc without this bug, the following code:
    For each tmp in Workbooks … Next

    will parse ANY excel window. In this case it seems that the VBA will see only the Excel where the macro is in.

  22. BobD

    As the Australians say, “Good’o mate!” (I’ve been watching Blue Heelers.)

    My registry didn’t have the “command” entry in the folder HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command/. I just skipped that step.

  23. dan

    Works for me. My command registry entry ends with”…………\EXCEL.EXE” /dde” but i simply follow his steps add a “%1” and it works! SOOOOOOOOOOOO NIIIIIIIIIIIIIIIIICE!!!!!!!!!!!!!!!!!!!!

    This is fantastic! Thank you!

  24. Peter Rosenberg

    I want to add to your (and others feedback) that the “%1” suffix may not work if your registry entries (for Excel) point to a quoted filepath !
    Then you have to add triple quotes around the %1, in order to make it work.
    Omitting these under this condition, my Excel would truncate Excel filenames to first word delimited name, so I got a lot of ‘Cannot Open file’ errors.

  25. John

    Doesn’t seem to always work when opening documents from Sharepoint 2003 with Office 2010. At least not when in the ‘All Documents’ view but it appears to be fine in the ‘Explorer’ view though. Opening local files seems to always work for me though.

  26. Bobby

    Did work for me, now I can’t open any Excel document without opening excel and then opening the saved file. My command file looked different to the 1 in the picture it had – /dde at the not /e as shown in the instructions. Should I change this?

  27. Riccardo

    Solution works partially. I can see now different windows, only the first file opened can be modified, the other files remain Read Only.
    Each file (except the first opened) gives this message:
    CDEEFD0C.tmp is locked for editing Open Read Only ..

  28. lisa

    The registry edit worked like a charm for opening and creating new documents but sadly it was incompatible with the files I already had on my desktop and even when opening current files I use on a thumb drive. The only way I could figure out how to view/ edit my files was to go back and undo the registry edit. I would LOVE to use this split window method if anyone could give me a tip on the fix.
    Thanks in advance

  29. lisa

    I just can’t even tell you how helpful this was!!
    The “dummy directions” pictures (I say that tongue in cheek) were very helpful.
    I have asked our IT group at both of my employers and neither could figure it out. I truly cannot thank you enough!!!

  30. Christopher

    Why not just run two instances of Excel? That’s what I always do and it works like a charm. I have one excel spreadsheet open, I go to my start menu and click on excel and a new blank one opens in another window. Then I close the blank one and find the spreadsheet that I actually want to open

  31. Alberto Santaballa

    Thank you, thank you, thank you. I came in this morning in a grumpy mood and opened two spreadsheets and then realized, again, that they were in the same window. Swore that was the last time no matter what it took. Hate that it has to be a registry edit, but such a relief to finally have them open as Word does. I owe you my firstborn.


  32. Marnus-ZA

    Thanks, followed the instructions carefully and it worked!
    It was freakin irritating that excel opens all windows in one window, like how do they think must multi-screen users use excel?

    Marnus-South Africa

  33. Benjamin


    Thanks for this. It worked for about 4 months, but then excel started opening *.xlsx files in the same window again. I note that now the registry editor has created new files “command” and my file “command2” still sits there. Similarly, it has created a new folder called “ddeexec” under excel sheet 8, yet my folder “ddeexec2” still remains. Can I just delete new ones it has created?

  34. gil

    Try placing your cursor over the start button (bottom left) and right click. Select “Properties” and make sure the Taskbar tab is selected. To the right of “Taskbar buttons:”, click on the drop down and select “Never combine” then click ok. There’s no need to change the registry if you try this. Hopefully this is what you’re looking for.

  35. gil

    Try placing your cursor over the start button (bottom left) and right click. Select “Properties” and make sure the Taskbar tab is selected. To the right of “Taskbar buttons:”, click on the drop down and select “Never combine” then click ok. There’s no need to change the registry if you try this. Hopefully this is what you’re looking for.

  36. Wanos

    Thanks dude! I’ve tweaked the registry before, but after rebooting, the issue would come back. This one actually stays permanent even after a reboot. I’m using MS Office Pro Plus 2010 32-bit, on Windows 7 Ultimate, 64-bit.

    If you guys are crashing/etc. make sure you guys are doing this right.

    FYI: I exported these reg keys so that next time I can just delete whatever’s there and just import the reg keys.

  37. Mark

    This seems to work if you open a file from the file system (desktop, shared folder, etc.). It doesn’t seem to work when opening a file from an internet location… such as your intranet! Anyone know how to make it work for that? Half of the files I open are from the intranet!

  38. John Ball

    Working just as you described in your post. I added the registry modifications to our Group Poicy computer preferences and pushed this to the entire domain. All is working great.

  39. avalon1959

    I did this and it worked to open up files in new windows, however now all my files open up as a new numbered XI0000000… files and not the original saved file. wtf? how do I fix this? It’s a real problem!

  40. RussM

    I tried this, but when I went to open a spread sheet it, if it had spaces in the file name it would try and open each word as a different document, i.e. “One on One Checklist” It would try to open Z:\One.xls, Z:\on.xls, Z:\One.xls, Z:\Checklist.xls. I also tried one with a single word name and ones that were on my C drive, I largely work with items on the network. I use Win 7 64 bit, Office 2007. Any help would be appreciated.

  41. Dustin


    This is what worked for me to solve Amy’s problem:

    1. Delete the new “command” that appeared but not the “command2” that you created previously.

    2. Modify the (Default) entry and add the “%1” at the end.

    3. Delete the new “ddeexec” folder that appeared but not the “ddeexec2” created previously.

    Excel files once again open in their own windows. I don’t know what causes this (perhaps a windows update) or if it will happen again. But the above steps worked for me for now, follow at your own risk.

  42. Sean

    I used your trick, and it worked great. But I can’t function without the ability to copy sheets to other workbooks. So I am trying to set things back to normal. I did all the steps in reverse order….but now I can’t click on an Excel file in a folder. It launches Excel, but then I get an error “There was a problem sending the command to the program.” How do I get back to the way things were? Thanks for your help.

  43. MikeXL

    This is all very well, but imposes limitations on functionality.
    For example, cannot copy sheets from one instance to a workbook in another instance. Or use format painting across instances.

    What I would like to see is an adhoc ability to open a workbook in a new instance. Would be great if a setting could be included in shortcut properties so that particular workbook always opens in its own session while others are open in multi-session.

    In particular for example, I have a VBA project that’s a complete running application and therefore means that other workbooks open in the same instance cannot be accessed

    For me, the most flexible way for now is to open a new instance and drag the workbook onto it.

  44. S.H.

    It works – but for excel 2012 (and I assume also for excel 2010) there exist some new filetypes for which you have to repeat the above steps.

    I did this for Excel.SheetBinaryMacroEnabled.12
    and Excel.SheetMacroEnabled.12

  45. Amy Lelliott

    I did this and it worked fine for a while, but after about a month it reverted back to opening multiple files in the same window.

    i tried to do the process again but because i already have ‘ddeexec2’ files from the previous changes, i don’t know what to do when trying to change the settings again.

    applying the changes to the command registry entry but not changing the ‘ddeexec2’ does not work?

    any help please?

  46. Ethan


    Same for me! win 7 pro 64 bit (heard 64 bit office is different)…i also had /dde and not /e Tried adding “%1” to the end of /dde and tried changing to /e…neither worked when trying to open excel files from outlook…they open in the same window. Also, if i open 1 excel, the xls opens in that one…i opened a 2nd excel, made that active, tried opening the xls and it opened in the first excel which was not active….any ideas?

  47. Brian

    I performed the steps exactly as mentioned and it made no difference for me, I am using Excel 2010 on Vista. Opening Excel files from links or clicking on files continues to open them in any currently open window of Excel :-(

    If is useful i noticed in my registry the end of the string to append “%1” to has a different ending than yours: “C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE” /dde “%1”

  48. rbrbrbrb

    1) If you don’t have it make a shortcut for Excel on the taskbar (drag desktop shortcut to the taskbar)
    2) Open Excel
    3) Right click on the Excel icon on the taskbar
    4) Select Microsoft Excel from the menu

    You can open as many instances of Excel as you want


  49. Raj

    Thaks for the post. I am using XP pro+Office 2007 and the command file is missing in my HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command folder so couldnt use your solution. I used part of your solution and did some tweaks to open Excel in new window every time. It woked. Please find my solutions below:
    Go to Tools-> select File Types tab -> select XLS file type-> click Advanced ->select Open-> Click Edit
    Add “%1” to the end in Application Used to perform Action: text filed (leave a space after /e) so that it looks like “C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE” /e “%1”
    Remove the DDE message [open(“%1”)] (keep it blank)
    Keep the Use DDE check box Ticked.
    Click OK
    Do the same for file type XLSX also.

    If the above didn’t work for you, try this 2nd option

    Go to start-> Take run (or press Win + R together)
    Type regedit.exe
    Click OK
    Go to HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command
    Right click on Default->Select Modify
    Add “%1” to the end of value data text field. If %1 is already there just add “ ” around it
    click Ok
    Do the same for Excel.Sheet.8
    Close Registry Editor
    Then in window Go to
    Tools menu->File Types tab-> select XLS file type -> click Advanced ->select Open-> Click Edit
    Application Used to perform Action: text field will look like
    “C:Program FilesMicrosoft OfficeOffice12EXCEL.EXE” /e “%1” (don’t change anything here)
    Remove the DDE message [open(“%1”)] (keep it blank)
    Keep the Use DDE check box Ticked.
    Click OK
    Do the same for XLSX also.
    This should work :)

  50. Tizwoz

    For goodness sake, WHY is everyone struggling with this when Thomas C. Sherman’s Excel Launcher just WORKS, every time, year in, year out (in XP/Excel 2003 anyway)! No messing about with the Registry, it’s tiny, and it’s as easy as falling off a log.

    Get it here:
    and here:

    It seems only one person (see No. 14 above) has got wise to this after I posted in No. 12 above, so Ashraf – PLEASE check it out and wise everyone up. I haven’t tested it, but it’s so simple that I bet it works with Excel 2007/10 in Win7/Win8 too (for those foolish enough to have Win8), but I’m prepared to stand corrected.

  51. Amy

    Hi – I did this yesterday and it worked just great, but today it’s no longer working. Is this something that just works for one session and you’d have to reset the registry each time you want it to work, or did I miss something?

  52. LCH

    Thanks so much, my Excel used to open files in new windows by default, but stopped doing so yesterday after I made a new worksheet for some reason. Silly how such a little thing can be so frustrating, but your guide worked like a charm. :D

  53. Cody Macurdy

    Just follow these steps and there is no need to replace the icon (at least in Windows 7):

    Start -> type “run” into the “Search Programs and files” and hit Enter -> type regedit and hit Enter:

    Left column: HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:

    Right column {adding (space)”%1?}: (be sure to include the quotation marks when typing)

    Double Click on (Default) and write – “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1?

    Right Click on Command – choose “rename” and add something to the name – for example 2 (commend2).

    Left column: HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:

    Right Click on the folder ddeexec and choose “rename” and add something to the name – for example 2 (ddeexec2)

    Left column HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:

    Right column {adding (space)”%1?}

    Double Click on (Default) and write – “C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1?

    Right Click on Command – choose “rename” and add something to the name – for example 2 (commend2).

    no restart needed. You can do this for .CSV files as well. Have Fun, and please share this answer with others. If the icon is not listed, you can right-click and go to Properties on any file that you wish to open with Excel, click the Change… button under the Opens With section, Browse…, look under C:\Program Files\Microsoft Office\Excel.exe (or under C:\Program Files (x86)\Microsoft Office\Excel.exe) and double click the EXCEL.exe; You may have to check the box under the Opens With section that states “Always use this file type…”

  54. Adnan

    On your last picture you have mentioned “1%” instead of “%1” which gives the error message of 1.xls could not be found.

    Also I didn’t have a command string on Sheet.12 so I have manually added a multi string and copied pasted the same value as in the Sheet.8 and gave it a command2 name. It seems to be working fine now.

  55. Dilip Louis

    I take a lot of pleasure in finding solutions to annoying little problems, and without great souls like you, me and others of my ilk will be very sad all the time.

    Here, have a virtual rose.

  56. Paul

    You have no idea how long I have needed this fix. Thank you so much for posting this, it works perfectly. Seems like basic functionality in a dual-monitor world. Not sure why this isn’t included natively with Excel.

  57. Jannine

    Hey thanks so much, this had also been bugging me…however I open many spreadsheets to compare via email attachments, opening multiple attachments even over different messages still causes them all to open in the same Excel window. Can anyone advise of a “tweak” for this?

    Thanks In Advance

  58. Tizwoz

    I am re-posting what I posted in No.12 above (as Celia – I since changed my Log-in) because, for some reason, only one person (see No.14 above) has picked up on this more simple solution: Excel Launcher. It works for .xls and .csv on WinXP, and although I have not tested on Win7 or Win8, it is so simple that I cannot imagine it would not work – perhaps someone will test on those two OS’s and post here with result?

    This is what I wrote before:

    Or you could use Excel Launcher – I’ve been using it for years & it works so well. It’s tiny & you just have to set Excel file types to always “Open With” it after you have first run it & pointed it to Excel.exe & you’re done! Get it here:
    That’s v.1.1, but I’m still using v.1.0 (get that here because, for some reason I can’t remember, I preferred it to v.1.1; but it’s a great little FREEBIE program – so big thanks to Thomas C. Sherman!

  59. Tim

    Much easier option within excel

    round office button > excel options > advanced > under ‘general’ settings > tick “ignore other applications that use DDE”

    Not sure file types it works with, but works with everything I use


    Thanks also from me BUT, Now after i done that in office 2007 i cant copy paste lets say a graph from one excel file to another and still work , cause it misses the conections, when i also use a formula and i want to add in it a cell from a totaly diferent excel file it doesnt work . it says that the file needs to be open ..

  61. Cornan


    My company uses a very large excel sheet for asset tracking and trying to work with it and other lists in the single window was driving me absolutely mad. I’d stumbled across the trick that Roc describes here in the comments but it’s honestly a pain in the butt and I vastly prefer not having to mess with it. Thank you again for posting this!

  62. Roc

    This works in 2010 without any reg changes
    1. Open the 1st workbook as you would normally.
    2. Move focus away from the workbook by clicking on some other window.
    3 Click Start:Program:Excel. This opens a new window and blank workbook.
    4 Keep focus on the new workbook and open the 2nd workbook into the new window.
    5. Repeat 3 and 4 as often as you need.

  63. Daivd Coe

    @Aaron: My changes works with /dde in the command line, so it should make no difference. Just rememebr the other registry lines must be renamed “command” to “command2” and “ddeexec” to “ddeexec2” or it will not work. You have to edit both Excel.Sheet.8 and Excel.Sheet.12 the same way. I have Win7-32bit, Office Pro Plus 2010.

  64. Aaron

    This initial tip by Ashraf worked wonders on my computer at home, however, at work I don’t have admin rights so I called IT and surprisingly they went onto my computer and adjusted the registry the way it needed to be. It didn’t work. I have an idea why but I was hoping someone could either confirm or offer a better reason….

    When you modify the ‘default’ registry to add the “%1” the end of the chain prior to it was a /dde, not /e like it was on my comp at home. Does this make a difference and will it work if I get it changed to /e? Can anyone offer any advice?


  65. Non


    This solution is also documented on MS’s Support section.

    Guess MS Office engineers just refused to fix a problem caused by themselves, so instead, issued this “fix” forcing the general public (who’s not computer savvy) to do the fix for themselves!

    Typical Microsoft >:(

  66. Justin

    Thank you for this!! I became so conditioned to manually reopen excel every day for multiple excel windows. This fix is perfect. I don’t get why they decided Word docs should open in new windows, but Excel docs should not. Anways, thanks again!!

  67. Peggy

    I am pretty computer illiterate but your steps made it so easy a 5-year-old could do it. Thank you so much, this speeds up my work flow immensely! Hopefully Microsoft will catch on eventually :)

  68. KC

    I really like this easy tutorial with pictures and it worked as described. However, I ran into my first problem only a few minutes later when I wanted to copy a worksheet from one file to another and now since they are separate Excel windows, I can’t have two open files and copy a worksheet tab between them. Any other tricks to solve this problem?

  69. Chakri

    The following would work for Win7 64 bit,(right click excel and open in new instance submenu)
    Open a notepad and paste the following and save it as:- Excel OpenInNewInstance.reg
    and right click merge…. you are done.. right click your excels and open in new instance

    Windows Registry Editor Version 5.00

    @=”Open In NewInstance”

    @=”\”C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\” \”%1\””

    @=”Open In NewInstance”

    @=”\”C:\\Program Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\” \”%1\””

  70. Gil

    This process didn’t work on my computer. The command line is slightly different than what’s shown in the examples. I even rebooted to see if that would apply the registry update – nothing. Oh well – I’ll keep looking!

  71. Stacy

    This is a really great post, thank you! I’m not terribly fond of Excel’s built-in window management tools, and it’s a bit annoying to always be starting up another instance of Excel just to force spreadsheets into separate windows. I was searching for something else, completely unrelated, but I’m definitely bookmarking this and going to try it out for myself. Cheers!

  72. simsan

    HI Ashraf,
    I tried the way you showed me to tweak and open excel. Something happened: I can now click on excel sheets already saved (made up), BUT these files DO NOT OPEN. A blank Excel page opens that lets me go to the main menu: file –> direct it to my saved .xls files, and yes it does open then, but not directly as i used to earlier.
    What wrong did i did or what happened here? Thnx —sim

  73. Celia

    Or you could use Excel Launcher – I’ve been using it for years & it works so well. It’s tiny & you just have to set Excel file types to always “Open With” it after you have first run it & pointed it to Excel.exe & you’re done! Get it here:
    That’s v.1.1, but I’m still using v.1.0 (get that here because, for some reason I can’t remember, I preferred it to v.1.1; but it’s a great little FREEBIE program – so big thanks to Thomas C. Sherman!

  74. Peter Dm

    I have tried this on XP SP3 machine and although there is no HKEY_CLASSES_ROOT/Excel.Sheet.12/ entry (only Excel.Sheet.8), I carried out the modification as far as possible. It still works OK.
    I also tried on Vista machine, which does NOT have the command entry to rename to command2, all other modifications to registry carried out. This also works OK. One extra point however, is that it does not work if the second file is opened from within the first. Thank you for a tip that solves an anoying problem for me.

  75. william neurauter

    I just went & started the process of making the modifications.
    for excel.sheet.12 their is no ‘command’ registry entry below the Default registry entry.
    Like wise there is no ddeexec folder under ‘Open’
    for excel.sheet.8 the ‘command’ registry entry is also missing; however there is a ddeexec folder.

    My ops is XP pro SP3.
    Any thoughts?

  76. SteveB

    @giancarlo: I downloaded and tried Office Tab, very interesting. The concept is great and is probably ok for most of the word processing that I do; however, there are times when I would like to have multiple windows open for Word and the freeware version of this software d provide the capability one must purchase full version. Not sure I’m that interested in the product.