Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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?

share|improve this question
    
I'm on windows 7 –  Martin Delille Aug 18 '10 at 14:08
1  
Running Windows 7 myself and Excel 2010, and when I open two different Excel files, they open in separate windows, which means I can put one on each screen. What is your selection on File > Options > Advanced > Display > "Show all windows in the taskbar"? –  JBirch Aug 18 '10 at 14:38
1  
Excel 2007 has a multi-window system? Where was that found? I have a custom add-in that adds the option to spread the Excel app window across multiple monitors (among other functions). That might be something worth looking at. I would avoid opening multiple instances of Excel, as this limits the work you can do between two books. –  variant Aug 18 '10 at 14:47
1  
@JBirch - got that checked, and got two buttons on the taskbar, but the windows are not separable. It's just one window, with two "fake" buttons on the taskbar. Can you show a screenshot? –  romkyns Apr 12 '11 at 18:52

3 Answers 3

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 the utility created by Nick/BitterMinion. Worked like a champ! [EDIT 12/2012: the utility is now called "Excel Launchpad", link updated]

share|improve this answer
    
Thanks that worked for me. –  Makky Jul 17 at 8:10

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

share|improve this answer

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_ROOT\Excel.Sheet.8\shell\Open 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_ROOT\Excel.Sheet.8\shell\Open\command should look like this: (Default) REG_SZ "C:\Program Files (x86)\Microsoft Office\Office12\EXCEL.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!

share|improve this answer
    
Can confirm this is what I did awhile ago and it worked for me –  Halfwarr Aug 14 '13 at 18:32

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

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