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. Good luck!!! 1. If you want to do the same thing for Excel 2007 files, you'll need to make the changes to the HKEY_CLASSES_ROOT\Excel.Sheet.12 key. Anyone have a solution to the same issue? (i.e. - opening two .ppt presentations into two separate PowerPoint windows on two different monitors, in one machine?) Thanks! .James. have a peek here
Thursday, February 10, 2011 8:01 PM Reply | Quote 0 Sign in to vote EVERYBODY in this post gave wrong reply!!!!!!! It only works if the user spreadsheet is the same day after day. OR RIGHT click on the Excel icon pinned to taskbar and LEFT click Microsoft Excel 2010will also open another instance. Tuesday, March 24, 2015 5:35 PM Reply | Quote 0 Sign in to vote Super helpful -- thanks Dave Tuesday, April 14, 2015 3:45 PM Reply | Quote 0 Sign in
Then, we can "Restore Down" each file and move them about the monitor and across multiple monitors. For example you can't do a VLOOKUP or even choose a cell value from the other window. Monday, February 04, 2013 4:09 PM Reply | Quote 0 Sign in to vote If you have Windows XP, here is what you can do: Download Excell Viewer (google it) and Thursday, October 31, 2013 6:39 AM Reply | Quote 0 Sign in to vote OMG!!!
Therefore I can't open through my documents. He was awarded the 2009 MVP award from Microsoft for his contributions in forums and blogs and is enjoying the new addition to his family. Pasted from
You then select the excel icon in the list (mine is Excel 2010) and a new instance opened right up. Excel 2010 Open In New Window Name E-mail (not published) Unfortunately, due to the volume of comments received we cannot guarantee that we will be able to give you a timely response. Great solution and easy; thanks krystle!!!!!! :-) Wednesday, January 09, 2013 4:25 PM Reply | Quote 0 Sign in to vote Worked great! http://superuser.com/questions/479639/how-to-make-multiple-excel-files-open-in-one-window-instance-of-excel-2003-in-wi What is a person who fakes responses on a survey?
Next you'll need to rename the ddeexec key here to ddeexec2 or something else: HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec This will make the change for the Excel 97-2003 filetype. Open Excel File In New Window You just saved me a good amount of time of searching for an answer. To access this setting, open Microsoft Excel. Thanks Reply Irina Pozniakova (Ablebits.com Team) says: September 29, 2016 at 10:03 am Hello Alan, I'm sorry, we don't know what may be causing these differences.
By using the start menu to open excel again, it opens as a "new instance" Reports: · Posted 8 years ago Top Tyralia Posts: 12 This post has been http://www.howtogeek.com/forum/topic/open-spreadsheets-in-completely-separate-windows I can try it at home, and let you know if this method works on Win 7. How To Open Excel Files In Separate Windows By Default This will let you have two windows of workbooks side by side and independent of each other.As an alterantive, if you want to see two different workbooks in the same window, How To Open Two Excel Windows On Separate Monitors This is a problem for me because I review a lot of documents that are e-mailed to me - and I don't necessarily need to save them.
Looking at spreadsheets in two different windows makes many Excel tasks easier. navigate here So naturally the users experience counts in my book and to try to help them out I created a shortcut on their desktop in Win7 and changed the shortcut key to Up for that? Minimize this windowand move it to the right screen. Separate Excel Windows On Two Screens 2010
Now all the Excel files will be opened as separate instance and you can move the Excel files individually across the monitors. Open Excel Workbooks In Separate Windows 2010 Drag thefirst Excel file that you wantto openinto the first Excel window and drag the second Excel file that you want to open into the second Excel window. I'm sorry that my instructions are not more clear or easier to understand, but I'm short on time and really wanted to share my find.
I know it's been a while, and you'll probably never see this, but thanks. Obviously opening a document that way would display the document in that given screen. All rights reserved. How To Open Multiple Excel Files In One Window share|improve this answer answered Sep 26 '12 at 7:51 HaydnWVN 3,02531441 add a comment| up vote 0 down vote I had the same problem.
Edited by Betlista Tuesday, July 01, 2014 8:52 AM reply not visible well Tuesday, July 01, 2014 8:50 AM Reply | Quote 0 Sign in to vote Thank you. I quit reading through posts at the time of frustration. Ken Blake, Microsoft MVP Wednesday, June 01, 2011 12:13 AM Reply | Quote 0 Sign in to vote Hey all, First let me say, I am not on a Mac, http://phpzipcodelocator.com/how-to/how-to-extract-files-windows-10.html Another neat trick someone mentioned was opening the first document via the start menu or desk top than on the bottom task bar hover your mouse over the Excel icon and
Reply Jeremy says: July 23, 2015 at 10:02 pm Sure, they separate, but are still stuck within the confines of that workbook. I can't begin to describe how happy and grateful I am. Friday, February 28, 2014 3:30 PM Reply | Quote 0 Sign in to vote excellent..thanks for sharing the simple solution. Install all Windows and Office 2003 updates.
I am using XP (with Office 2010) at work, and that is mainly what I needed to open multiple instances up for, I don't know if it works on Windows 7, One of them is selecting the "Ignore other applications that use Dynamic Data Exchange (DDE)" option in Advanced Excel Options. You will then just be able to double click on an excel document and it will open a seperate isntance of excel. Windows menu...You can both open the excel sheet on the same instance as default by excel or seperately it works both way.Tell me how it went on...Dwij 0Votes Share Flag Collapse
Wednesday, April 11, 2012 3:14 PM Reply | Quote 3 Sign in to vote If you are working almost the entire day in front of your computer at your office with Change the Code, Change the Sequence: Cops What Dominion Cards use victory tokens? Reports: · Posted 8 years ago Top Tyralia Posts: 12 This post has been reported. Has anyone had any luck doing this?
Press and hold the Shift key on your keyboard and click the program icon on the taskbar. Now, I can't say anything about other people and variations on their PCs: results might differ.