May
31

How to open Excel 2010 files in separate windows

Once we covered how to view Excel workbooks side by side. But there is another, presumably non-standard, task that appears to be very popular - to open your Excel 2010 or 2007 spreadsheets in different windows. I've read all the complaints and solutions on the Office forums, and this post will try to provide the summary of the easiest ways to go, which don't require messing with the registry.

3 solutions that actually work

Solution number one - Excel icon on the taskbar

Open your first table, then use one of the following four ways to open a new instance:

  • Right-click Excel icon on the taskbar and pick "Microsoft Excel 2010" (or 2007):

    Open a new window with Excel using the taskbar icon

    Then navigate to File -> Open and browse for your second table.

  • Press and hold the Shift key on your keyboard and click the program icon on the taskbar. Then open your second table from the new instance.
  • If your mouse has a wheel - click on the Excel taskbar icon with the wheel.
  • If you have Windows 7 or an earlier version, you can also go to Start menu -> All Programs -> Microsoft Office -> Excel, or simply enter Excel in the search line and click on the program icon. This will always open a new instance of the program.

    Start a new Excel instance from the Start menu

Number two - Excel shortcut

  • Open the folder where your Office is installed. The default path for Excel 2010 is C:/Program Files/Microsoft Office/Office 14. If you have Excel 2007, the name of the last folder is Office 12.
  • Find the Excel.exe application and right-click on it
  • Choose the option to Create shortcut and send it to your desktop.

    Create a shortcut to Excel

Whenever you need to open a new instance of Excel - double-click this desktop shortcut.

Number three - Excel option in the Send To menu

If you often have to open two Excel windows simultaneously, see this advanced shortcut solution suggested on the forum. It is actually easier than it may seem, just try it:

  • Follow the steps above for creating Excel shortcut;
  • Open this folder on your computer: C:/Users/UserName/AppData/Roaming/Microsoft/Windows/SendTo
    Note. AppData folder is hidden. To make it visible, go to Folder options in Control Panel, switch to View tab and select to "Show hidden files, folders, or drives".
  • Paste the shortcut into the SendTo folder.

    Add Excel as an option in the Send To menu

Now you can avoid opening your second file from within Excel. You can right-click the file you want in a new instance, and choose to Send To -> Excel.

Other suggestions that may work for you

There are two other solutions that work for many people. One of them is selecting the "Ignore other applications that use Dynamic Data Exchange (DDE)" option in Advanced Excel Options. The other one involves registry changes.

Looking at spreadsheets in two different windows makes many Excel tasks easier. Trying to view the files side by side eats a lot of space and it isn't always the best option. The advantages of two files comprise something more than just the ability to compare or view sheets next to each other. If you corrupt the data in one file, you won't have to re-open all other documents from separate instances.

You may also be interested in:

Workbook Manager for Excel - try this tool to quickly switch between data sheets, move them around, and carry out all similar daily tasks in a click.

37 Responses to "How to open Excel 2010 files in separate windows"

  1. Øyvind Øverby says:

    There is a much simpler method:
    All you have to do is to create a shortcut on your desktop that points the Excel executable file and then edit the target box in the shortcut property to read:

    "C:\Program Files (x86)\Microsoft Office\Office14\EXCEL.EXE" "C:\Folder name\Subfolder name\Name of Excel file.xlsx"

    Remember to type the quote marks (all 4), and replace the path and file name in the example above with the correct path and filename of your choice.

  2. Happy says:

    Thanks for that, it helped me :)

  3. Joe says:

    That worked!!! Thank you for sharing with the community!

  4. Gareth Mitchell says:

    Top Tip! Thanks for this. If you can work out how to get the Classic View back so I can get rid of this useless Ribbon it would be fantastic too.

  5. Missy says:

    OMG!! Thank you. That has been driving me crazy for a week and all the other solutions I found were way to complicated. This was perfect and easy.

  6. Ben says:

    Thank you so much for the tips.

  7. Eva says:

    There's a minimize button under the main minimize button. It sounds absurd, but look under the main minimize button, you'll see another button.
    Click on that, and your excel files will separate.

  8. Karthik says:

    Simple Things are always hard to put together. Great Post !

  9. Lyon says:

    Thanks.
    Cannot believe smart people in Microsoft came up such stupid idea

  10. Phil says:

    While this is a good solution for many, my issue revolves around opening excel files from email without saving them to my computer first.

    Suggestions for this issue?

  11. G says:

    Thanks for this! Simple but effective

  12. nal says:

    The "Send To" solution is by far the best and easiest for opening existing Excel Workbooks. Thanks.

  13. Lin says:

    Thank you for the "send to" that was A+ perfect.
    I have been trying to google this the right way to figure this out.
    I don't want to mess with the registry to solve this as in numerous
    posts. Plus the uncheck dde didn't work for me either.
    Thanks again!

  14. ruth says:

    Thanks a million!

  15. Lalitha says:

    The second option I have used and it worked. Very good.. Thanks...

  16. Laura says:

    Any suggestions for being able to do this for an excel email attachment in Outlook?

  17. Lesley says:

    Thank you so much!

  18. Alyssa says:

    This worked, however, now I can't cut and paste between the 2 workbooks! Or move sheets between them. They don't talk. Am I missing something? This will not be a good solution for me on all occasions.

  19. Menka Bihari says:

    Thanks so much for the easy description...I used the first method and was able to open a separate file right away! This is great!

  20. Hewad says:

    Superb!! tip.

  21. Jessica says:

    Thank you! This is the only article I could find that answered my question!

  22. alan says:

    Ok, system info is as follows: win 7, office 2010, registry is NOT hacked with the %1, the Ignore DDE option box in excel is NOT checked. I have 2 computers exactly same as above yet 1 opens all excel files in seperate instances and the other opens them all in the same instance. There must be another option somewhere that tells excel to open all spreadsheets in a different window wthout hacking the registry or ignoring DDE. I cannot find this option anywher. Who knows the answer? Thanks

  23. Dileepa says:

    Excellent. It worked for me very well..

  24. Mandy says:

    OMG. Its working. Thank you so much.

  25. Nate says:

    Fantastic! This just made my week!!!! Thanks!

  26. Jakison Ojha says:

    Thanks. 1st one easy one and worked.

  27. Lauren Fougere says:

    All you need to do is instead of double clicking on the excel document to open.
    open excel by going to start – Microsoft excel – file open - open first document
    Do the same thing open the second document and it will be separate.

  28. Vlad says:

    While this is a solution, it doesn't completely solve my problem. I work with a lot of excel files, from different locations. Opening, closing, comparing... It's not a problem to open a new Excel window, just use the start, but than finding the file to open from the browse each time really gets on my nerves. Going from internal folders, to external hard-drives or network folders.....

    Basically I need a way to open a file directly in a new window.

  29. Angel says:

    Very helpful! Thank you!

  30. Ryan says:

    Opening one Excel file and then right clicking the Excel taskbar icon and clicking "Microsoft Excel" works. Thank you! Such a simple solution but it's not obvious since Excel files don't open the way Word files do.

Post a comment



Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. When posting a question, please be very clear and concise. We thank you for understanding!
Excel add-ins and Outlook tools - Ablebits.com
Ultimate Suite for Excel Professionals
 
 
60+ professional tools for Excel 2016-2007 to do your daily work
Incredible product, even better tech support…AbleBits totally delivers!
Deborah Bryant
Anyone who works with Excel is sure to find their work made easier
Jackie Lee
The best spent money on software I've ever spent!
Patrick Raugh
Ablebits is a fantastic product - easy to use and so efficient.
Debra Celmer
Excel is at its best now
Annie C.
I don't know how to thank you enough for your Excel add-ins
Jennifer Morningstar
Anybody who experiences it, is bound to love it!
Kumar Nepa
AbleBits suite has really helped me when I was in a crunch!
Nelda Fink
I have enjoyed every bit of it and time am using it
Christian Onyekachi Nwosu
It's the best $100 we've ever spent!
Mike Cavanagh
I love the program, and I can't imagine using Excel without it!
Robert Madsen
One word… WOW!
Dave Brown
Love the products!
David Johnston
It is like having an expert at my shoulder helping me…
Linda Shakespeare
Your software really helps make my job easier
Jeannie C.
Thanks for a terrific product that is worth every single cent!
Dianne Young
I love your product
Brad Gibson
Awesome!!!
Sheila Blanchard