How to Open Two Excel Files Side by Side in Separate Monitors?
If you are new here, Subscribe to Full Feeds or by Email or follow us in Twitter and receive free daily updates on Office and Windows Tips, Tricks and Tweaks..
If you are working almost the entire day in front of your computer at your office with lots of Excel Sheets and Word, then probably you might be working with a dual monitor or may be even more than that. Studies have shown that having an additional monitor increases the productivity by 20 to 30 percent (Source: NY Times)
But some applications like MS Office Excel, even though you open multiple files, they are all from the same instance of the application. So if you want to compare two Excel files, then you may not be able to have it in two separate monitors as the files are loaded using the same instance of Excel. If you move one Excel file to the other window, the other Excel files are also moved to the other window.
So how to have two separate Excel files or other application side by side in dual monitors?
Option A:
In Excel 2003, go to Tools -> Options -> General tab.
Make sure the option, ‘Ignore other applications’ is checked. Now all the Excel files will be opened as separate instance and you can move the Excel files individually across the monitors.
In Excel 2007, Click the Office button -> Excel Options -> Advanced.
Under General, check ‘Ignore other applications that use Dynamic Data Exchange’.
As this method forces each Excel file as a separate instance, the memory consumption will be more. If you don’t want too many memory consumption then you can open only two instances (see Option B) and manage wisely to view in both the monitors.
Note: If you are having issues like Excel opens without displaying a workbook, then you may have to uncheck this option. (See Microsoft Help for more details on this). You can use option B in this case. I have this option checked and I have not faced any issue yet.
Option B:
They key here is, the application has to be loaded as separate instances. Lets say you have opened an Excel file in Monitor 1 and you want to open the next excel file in Monitor 2. You can usually open another instance of Excel by browsing through the Start Menu -> Programs -> Microsoft Office -> Excel. Make sure this newly opened Excel file is the last Excel file you had viewed and then double click on the Excel file that you wanted to open. This will force the Excel to open in the second instance of Excel. Now you can move these two excel files separately across windows or monitors.
This may be little cumbersome way to open new instances of Excel every time. The easy solution would be to keep these links in the quick links near the Start button. So, every time you want to open a new instance of the application, you can just use those quick links.
Never had to use this feature. Still I had thought how to do this.
This is something that I always wanted to do but not able to.. Great tips! Makes my job much easier!
Hey thanks heaps for this, it has been bugging me for ages
Now the only issue I’m having is now that I’ve ticked the box to ignore other applications I can’t open files from explorer (by double clicking)in excel. It keeps coming up with file not found (in excel).
The only work around it seems to be unticking that box.
Thanks again mate tho.. still helpful when I want to use excel on dual screens
[...] How to Open Two Excel Files Side by Side in Separate Monitors? [...]
I was searching in vain to try and find a way to address this problem from my work machine and this article hit the nail on the head. Thanks much!
[...] to LyteBite, people like midlakewinter are now able to have two spreadsheets open on separate monitors. Mac Office 2008 opens everything in a new window, but if you’re 99% of the modern office, [...]
this is a good idea, however using more than one instance of Excel means that copying from sheets works differently.
For example, if you have 3 columns (A to C) with 10 rows of data, and filter column A by all beginning with “x” which returns 5 rows. if you copy it into your other instance of excel, it will copy ALL data, not the filtered data. but with a single instance of excel it works fine.
just a point to be aware of.
[...] How to Compare two Excel Files in Dual Monitor Side by Side? In Excel 2007, Click the Office button -> Excel Options -> Advanced. Under General, check ‘Ignore other applications that use Dynamic Data Exchange’. This worked. (tags: Windows Monitors Excel) [...]
I love you!!!!It worked!!!
When I tried Option A in excel 2007 it would not open the file (as you mentioned in your note). Option B was not ideal for me as I like to browse to the specific file and open it through Windows Explorer.
I put together another solution that will open Excel in a seperate window every time a file is opened.
Unfortunately, copy-paste no longer pastes formulas between the spreadsheets. (either method)
Anyone know of any methods to fix this? (Or some VB code to tell it to paste-special in a form that retains the formulas (that I could e.g. map to Ctrl-shift-V))
thank you very much it worked…
This is what I have been looking for – excel help was useless
Thanks
Perfect, Thanks.
Checking the “ignore other applications” box is a great tip!
However, when I then close the files, I lose this function, and have to re-check every time. Is there a way to “save” the “ignore other applications” command, keeping it always operative?
Thanks,
Jeff
Great….
Wow..simple but it’s work..
Long time ago I’ve done open excel 2003 at XP,also excel 2007 at XP and Vista (with change at folder option and file types).
But its never work is you run excel 2003 at Vista, and you did it..
with very simpel way…great job…
thanx for posting this..
i am thankfull of your usefull information and i completly solve my problem today i was faced with a problem with excel sheet that how i should use in different window the excel sheet i am an IT manager in Afghanistan
To time consuming and resource heavy method, Marco which fits one instance across two screens then another marco to put the sheet slected tomonitor you want is the quick way to do it.
The above methoed does not allow you to look at the same file but diffrent tabs in each monitor. Macro will allow to do that. Now if I can just find the marcos I have been using on the internet since my computer was wiped.
Options to use two monitors effectivly are limited in the Office Suite. Macros all the way.
Im on 07 and the first option will not work, when I try to open an excel doc it is blank… the 2nd option worked great.
thanks
Vista and Office 2007
I was having the exact same issue as Jeff Roth
March 25, 2009 at 4:06 pm very very annoying.
There seems to be a problem with the option avalible in Excel Options->Advance-> “Ignore other applications that use Dynamic Data Exchange (DDE)”.
When checked the key ‘ddeexec’ @ HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ should be ignored, this does not seem to happen and when the option in excel is ticked I was getting file location errors.
workaround:
Delete the key ‘ddeexec’ and its sub keys in the action you want to change. (for me it was simply when using ‘open’)
You also need to add the “%1″ to the (default) string located @ HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command because now the burden of loading the file is on the command line call rather then DDE inside excel.
If you want .xlsx do work the same just replace the path Excel.Sheet.8 with Excel.Sheet.12
Excel.Sheet.8 (associated with .xls)
Excel.Sheet.12 (associated with .xls)
Anyhows thats what worked for me.
This solution below was the closest to anything that helped on the Internet. Thank you Playdoh…. the only problem I am still having is that when we double click an Excel file it is opening excel without the file open. When we go to Open and open the file, the file is there. It’s just opening a blank instance of Excel instead of the file we are double cliking on in Excel. Any other suggestions to add to the registry changes?
Thank you in advance,
Shawn
There seems to be a problem with the option avalible in Excel Options->Advance-> “Ignore other applications that use Dynamic Data Exchange (DDE)”.
When checked the key ‘ddeexec’ @ HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ should be ignored, this does not seem to happen and when the option in excel is ticked I was getting file location errors.
workaround:
Delete the key ‘ddeexec’ and its sub keys in the action you want to change. (for me it was simply when using ‘open’)
You also need to add the “%1? to the (default) string located @ HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command because now the burden of loading the file is on the command line call rather then DDE inside excel.
If you want .xlsx do work the same just replace the path Excel.Sheet.8 with Excel.Sheet.12
Excel.Sheet.8 (associated with .xls)
Excel.Sheet.12 (associated with .xls)
Anyhows thats what worked for me.
Thank u for this tip! At my work i’m at dual screen, but never managed to get Excel on 2 screens. But now it finally works, great! I used option A btw.
Thanks again!
Worked like a charm! Always wondered how I would do it, a simple Google search pointed me in the right direction. Thanks a lot!