Double-click the Excel icon to open another instance of Excel. This has annoyed me since 2007 when Microsoft introduced the functionality in Word but not in Excel. I found this trick and followed it step-by-step and now, i can open excel files as much as I wanted and they can be seen all of them without and switching pages. Tried using a shift+return and seemed to lay the response out fine in the browser - but stripped that formatting in the actual post. The advantages of two files comprise something more than just the ability to compare or view sheets next to each other. Extend the Excel window to cover both screens by dragging the window edges. Then open your second table from the new instance.
This is the only way I found to open two Excel files in separate windows under Windows 7. Excel spreadsheets will now open as a new file each time. I couldn't seem to get a ctrl+enter or alt+enter to work for a return, and previous line returns also ran together. 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. When you open multiple Microsoft Word documents, you are able to put one on your main monitor and one on your secondary monitor to compare, copy and paste from one document to another. I need to open new Excel and then open current file in separate window. Can it be done with Excel 2010? Before you do this, I highly recommend you backup your registry.
Net cannot verify the validity of the statements made on this site. Although you are the user that has the workbook open, Excel will still inform you of this. But the chances are if you are running you have a ton of memory at your disposible. Bottom of the dialogue box that opens, it gives an Excel Options button - click it. Open the excel program from the start menu or create a shortcut and open that. If you corrupt the data in one file, you won't have to re-open all other documents from separate instances.
Maybe I am missing something here, has anyone run into this issue? Again, this all excel documents being opened in a separate instance, which the question explains leads to a whole slew of other problems such as not being able to copy formulas or formatting between sheets. I have hundreds of excel files, scattered among many folders. The registry no longer appears at least with my skills to be able to accept those type of changes. What does Windows 7 open documents under the same window? Changing the wrong thing in your registry can cause major issues with your computer. I found some others that outlined some Registry tweaks. Note that each one has its own window and ribbon: How to arrange your windows Now that you have multiple windows, how should you arrange them? Each of these instances has for example it's own toolbars.
I checked the registery, the path is correct. As far as I can tell, since you're opening a second instance of Excel, you can place it wherever you wish. Maybe you want to use two or more Excel spreadsheets at the same time opened each file in separate windows , or open them on two monitors. By default, it seems Excel 2007 and 2010 open separate files in the same instance of Excel. Changes to make in the Registry Warning: The steps below outline manual changes to be done on your Windows registry. If you want to force to open yourApplications especially Excel, Word, Internet Explorer, Firefox in anew window, then I have the solution. Hey, I want to open multiple Excel 2007 files in separate windows because I have 2 separate monitors.
Such opinions may not be accurate and they are to be used at your own risk. After months of frustration each time I had to open several excels every day , I spent about 2 days to reach your answer and it works! They do this because by keeping your documents open under the same window, they are able to only open 1 process to run the application. It's especially useful if you have got two monitors. . I looked and found some solutions for 2007 and prior versions however I did not find any solutions for the Win7 Excel 2010 environment.
Microsoft Office I'm not sure if it because the files are 2003 or not? When you open a separate windows this is supposed to greatly increase memory usage. I am on Win 7 Pro with Office 2010 64 bit. Both versions ofExcel are 32 bit as far as I. Lot's of great ideas here, and seems to find a way to work for many. Dozens of times is not an exaggeration. This allows you to have the workbook open on separate windows, but you will only be able to make edits in the first one.
For example setting folder options for Excel files? I have the home and student version which allows five installations. It's kind of a catch 22. I could fix the issue with the first one. It does not alter the default behaviour of Excel in any way. 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.