Open Excel 2010 Files In Separate Windows

1. Microsoft Excel 2010 Open Files In Separate Windows
2. Excel 2010 Open New Files In Separate Windows
3. Open Two Excel 2010 Files In Separate Windows
4. How Do I Open Multiple Excel 2010 Files In Separate Windows
5. Excel 2010 Open In Separate Windows
6. Force Excel 2010 To Open Files In Separate Windows
7. Make Excel Open In Separate Windows

Mar 12, 2018  Generally, the Ribbons are separate, but they are certainly not independent instances of the Excel application, as the application settings are shared between all the windows. The previous process to create a new instance will, in Excel 2013 and later, open a new workbook in the same instance, rather than a separate one. Office 2010; Opening Excel Files from multiple sources (Outlook 2010, Desktop, OneNote 2010, etc.) New laptop with 12GB of RAM; i7 Quad Proc. Problem: By default, all of my Excel books open in the same window of Excel. I open lots of sheets that need visual side-by-side comparison. I want every every Excel book I open to have its own Excel window. How to open/view multiple Excel files in different windows. First, you need to open multiple instances of Excel 2010, and then separately open the Excel files in different instances of Excel, so that you can view the workbooks in different monitors at the same time. Step 1: Open multiple instances of Excel 2010.

With office 2010 I would like to open two excel document on different monitor.The only way I achieved to do this was to widden the Excel main window over the both screen which is not very convenient because:

• the mouse operation is not so easy.
• it hides what is between the two excel sheet.

Excel 2007 used to perform this very easily with a multi window system. Is there a tricks for 2010?

4 Answers

You can run multiple instances of Excel by selecting Excel in Start -> All Programs -> Microsoft Office -> Microsoft Excel 2010. Or better yet pin this to the start menu or quicklaunch/taskbar. You then have multiple instances.

If you then have the issue of opening Excel by double-clicking on an Excel file, then you can do the things related in this post Open Excel Files In New Window. I'm on Win7x64 and had to install Excel Launchpad. Worked like a champ!

[EDIT 12/2012: the utility is now called 'Excel Launchpad', link updated]

[EDIT 7/2017: updated link]

Another trick in Windows 7 is to Shift-Click the Excel item in the task bar to open a new instance.

Got this from an outside source and thought I would share :) In Windows 7 you have to edit the registry to remove DDE completely. This should work for Vista too. Check the 'Ignore other applications that use Dynamic Data Exchange (DDE)' box in Excel -> Excel Options -> Advanced This alone might work for you by itself - didn't for me, I got an error every time I double-clicked on an excel document. BACK UP your registry.

Open regedit, browse to HKEY_CLASSES_ROOTExcel.Sheet.8shellOpen Delete the ddeexec key, (or just rename it if you are worried - i just renamed it and it worked) Then click on the 'command' key and replace the /e on the Default and command string in that key with '%1' Quotes around %1 are important. NO QUOTES MEANS NO WORKIE!!!!

HKEY_CLASSES_ROOTExcel.Sheet.8shellOpencommand should look like this: (Default) REG_SZ 'C:Program Files (x86)Microsoft OfficeOffice12EXCEL.EXE' '%1 command REG_MULTI_SZ vUpAVX!!!!!!!!!MKKSkEXCELFiles>tW{~$4Q]c@II=l2xaTO5 '%1'

Do the same for Excel.Sheet.12 Now Both .xls and .xlsx should open in new windows with no errors.

I have confirmed that the same problem occurs in Office 2010x64 (32bit probably also) when checking the dde option. This should fix All vista and windows 7 problems with opening excel in seperate windows :) Enjoy!

From: http://social.technet.microsoft.com/Forums/office/en-US/c42f825d-b7e8-48c8-b5af-30563b839f09/windows-7-cannot-run-multiple-instances-of-excel-using-ignore-other-applications-that-use-dde

Works for me!

simply open new tab on the window and just go to open file..browse .. and open the file..it will duplicate windows.

Enjoy..

Not the answer you're looking for? Browse other questions tagged multiple-monitorsmicrosoft-excel-2010 or ask your own question.

When I have Excel running and I double click an Excel file in Windows explorer, I'd like it to launch in a new window by default so that I can move documents to separate monitors. Is there any way to get this behavior?

14 Answers

I've had this problem too. Here's what I did:

In Excel 2003, go to Tools -> Options -> General tab.

Make sure the option, ‘Ignore other applications' is checked.

In Excel 2007 & 2010, Click the Office button -> Excel Options -> Advanced.

Under General, check ‘Ignore other applications that use Dynamic Data Exchange'.

I don't know why this isn't built in.Source: http://www.lytebyte.com/2008/05/13/how-to-open-two-excel-files-side-by-side-in-separate-monitors/

It's a bit back to front, and will work for any program not just Excel, but I middle-mouse-button click the Excel icon in the Windows 7 Taskbar and create a new instance of Excel, then open the documents in each instance of Excel.

Once your have multiple instances of Excel running you can arrange them side by side by holding down Shift and right clicking on the icon:

There are certain disadvantages to having all your workbooks opened in different windows. For one thing, if you write a formula in one workbook which references another, it will include the full file path of the other workbook. For another, copy/pasting from one workbook to another reduces the number of options available for the destination data, like keeping the column widths, etcetera. It's possible that for your purposes those things won't matter much, but basically if you experience any 'weird' behavior when using multiple workbooks in multiple windows, you might try opening them in the same window to see if the weirdness goes away.

My preference is to leave the default behavior to open Excel workbooks in the same window, and when I want individual workbooks opened in different windows I right-click the file and select 'Open in new window'. In order to do that, I wrote this small utility. It's free. Feel free to install it.

I followed the guide published here.

In short:

1. Open regedit (win+R, regedit)
2. Browse to HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/command
3. In the tab on the right:
   • Right click on (Default), select Modify.., append a space followed by '%1' (including quotes)
   • Rename command into command2
4. In the tab on the left:
   • Just below the command folder (whose name is left untouched),
     Rename ddeexec into ddeexec2
5. Browse to HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command
6. Repeat step 3 and 4
7. If you want this to be valid also for csv files,
   Browse to HKEY_CLASSES_ROOT/Excel.CSV/shell/Open/command
8. Repeat step 3 and 4 (or just repeat step 6 :) )

This worked for Microsoft Excel 2007. In case of update you might have to repeat these steps.

I personally liked this manual approach because is reversible. With respect to some of the other proposed solutions, I love the fact that you can so easily open 2 files with the same name.

Excel 2007: If you have access to edit your windows registry, here are a few registry files that add the option to open in a new instance (either by default or not) when you right-click on your files so you can use both functionalities.

There is a .reg file to 'uninstall' it as well. Tried and tested in excel 2007 (32-bits windows). I believe the technique is the same as in hyperslug's answer: DDE or not.

Since hyperslug's answer didn't work for me, I followed 'Option B' from his link and now open a new (empty) Excel from the start menu and drag'n'drop the file I want to open into the new window.

In Office 2013 they solved this issue. Each workbook is in its own window in Office 2013.

Here's another set of registry files I (which I created) to solve the same problem: http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/A_1007-Option-to-open-excel-2007-documents-in-a-new-instance.html?sfQueryTermInfo=1+30+excel+instanc+new

Gives a right click menu to open excel files in a new instance, and optionally makes it the default behavior, but still leaves the option to open it in an existing instance if the workbooks need cutting and pasting with formatting between them.

Microsoft Excel 2010 Open Files In Separate Windows

Excel 2010 Open New Files In Separate Windows

finally one regedit instruction that works for my windows 7 and excel 2010

Open Two Excel 2010 Files In Separate Windows

To launch multiple instances of Excel, we change it by not using DDE to open the file. Check the 'Ignore other applications that use Dynamic Data Exchange (DDE)' box in Excel -> Excel Options -> Advanced

If this does not work,for Windows Vista and Windows 7, we need to edit the registry to remove DDE completely. Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs.

Mar 05, 2017  Ratchet and Clank is a Third-person Perspective, Platform and Single-player shooting video game developed by Insomniac Games and published by Sony Interactive Entertainment. The game takes place in the stunning environment and puts you in the role of the protagonist named Ratchet. It offers the similar gameplay like its previous edition and allows you navigates the environments, fight. Oct 10, 2016  Looking for a game like Ratchet and Clank on PC? So I took a nostalgia hit last winter. I bought the Ratchet & Clank Collection Remastered and Future: Tools of Destruction on PS3. I played a bit of both of them and they were awesome. The closest thing I've gotten on PC is the Going Commando emulation. It's runs decently, aside from some. https://meahalanka1977.mystrikingly.com/blog/add-a-blog-post-title.

1. Click Start, in the Search box, type regedit and press Enter.
2. Locate the registry subkey: HKEY_CLASSES_ROOTExcel.Sheet.14shellOpen
3. Delete the ddeexec subkey.
4. Click on the command subkey, and then double-click the Default value from the right pane. Replace the value data with: 'C:Program FilesMicrosoft OfficeOFFICE14EXCEL.EXE' '%1' Double-click the Command string value, replace its data with: (f'^Vn-}f(ZXfeAR6.jiEXCELFiles>!De@]Vz(r=f1lfq?R& '%1'

Thank you to sally tang , on this forum https://social.technet.microsoft.com/Forums/office/en-US/ee76d08d-3306-406d-894c-16fd3cb824d9/each-workbook-in-separate-windows-excel-2010-windows-7?forum=excel

Another solution is to merge a .reg file with the following content into Window's registry (change the path to EXCEL.EXE according to the version and installation path you have and add any additional file types you want to remap (Excel.Sheet.12 is for .xlsx files and Excel.Sheet.8 is for .xls files)):

(You may want to back up your existing HKEY_CLASSES_ROOTExcel.Sheet.12 and HKEY_CLASSES_ROOTExcel.Sheet.8 branches (via regedit.exe's export) in case you want to revert this change.

If, after applying this file, you want to open another file in the same window, use the file menu to open another file and it will open in the current window.

Microsoft has patched this already. You can download the patch here:

Running the patch does everything being said in the 'Let me fix it myself' section.

How Do I Open Multiple Excel 2010 Files In Separate Windows

This thread is old, but the problem is persistent! Hyperslugs solution didn't work for me, but I found a nifty launcher application that middle-mans the opening of excel documents and forces new instances. It can be found here http://blog.thomascsherman.com/2010/06/opening-excel-files-in-new-processes-excel-launcher-helper-app/ . I hope this helps someone with this annoying problem.

I use Excel 2010, and wanted to open a new instance for the purpose of being able to easily switch between spreadsheets. I use Alt+Tab which doesn't work with excel's default settings. If this is the main reason you wish to open a new instance for each spreadsheet, it can be resolved by;

1. Open Excel
2. Open the File Menu
3. Click 'Options'
4. Click 'Advanced'
5. Scroll down to 'Display' Section
6. Check the 'Show all windows in the Taskbar' box

This makes it easier to switch between spreadsheets, but if you're looking to view two spreadsheets simultaneously (i.e. if you have multiple monitors) you will still have to open a new instance of excel and open the file from within that instance.

Disabling DDE seems like the best option, but as others have pointed out, that causes Excel to open a blank window when you try to open a spreadsheet through Windows Explorer. If you usually open spreadsheet through Windows Explorer, I found that the best option is to re-associate the extensions and specify your own command.

To do that, open command prompt as an administrator and run the following commands (modifying the path to match your Office install):

This will cause a new window to open whenever you double-click an Excel file. It also fixes the behavior when you right-click the Excel icon and select a recent spreadsheet. However, it will not fix the behavior when you open a spreadsheet through the Open dialog in Excel -- those will still open in the same window.

NOTE: If you place the above commands in a batch file, you will need to use '%%1' in place of '%1'.

Excel 2010 Open In Separate Windows

protected by Community♦Dec 14 '16 at 5:27

Force Excel 2010 To Open Files In Separate Windows

Thank you for your interest in this question. Because it has attracted low-quality or spam answers that had to be removed, posting an answer now requires 10 reputation on this site (the association bonus does not count).
Would you like to answer one of these unanswered questions instead?

Make Excel Open In Separate Windows

Not the answer you're looking for? Browse other questions tagged microsoft-excel or ask your own question.