I cannot find this option anywher. Sure, each one has it's own taskbar button to switch between them, but if I want to work on one spreadsheet on one monitor while looking at the other spreadsheet on my other monitor. But it seems that the renaming of the command and ddeexec was what I was missing, thanks! Office 2007, Windows Server 2008 x64. I wonder why they would have that default setting? As long as you establish a preferred term, possibly in your Style Guide or other business materials, your workers should be able to understand what you mean when you discuss opening spreadsheets and workbooks. Goofing up changes in your Windows registry can cause serious problems — so proceed at your own risk. I agree with Vlad on this. Fortunately, there is a way to force Excel to open spreadsheets in new windows.
Does anyone know what registry keys need to be modified in order to open macro enabled excel files in a separate instance of Excel ie: separate windows? Then, you can restore the registry if a problem occurs. Open Excel workbooks in new windows with creating shortcut The last method for opening Excel workbooks in new window is to create a shortcut. I've been able to do this for 25 years, before Windows 10 came along. One of those keys is named shell. .
Run Office Diagnostic see whether it corrects the Problem. Finally, as Step 12 implies, if there are other extensions that Excel supports which you would like to open in a separate instance, just repeat steps 2 through 11 for each extension. This works with for example Word just double click on two different word files but not with Excel. Maybe we should start requesting it. I am curious though, if you go in Start. See screenshot: Then the selected workbook is opened in a new window as below screenshot shown: Tip. If you can do that, I'd buy it for a fair price.
Is this link of any help to you? Backup it in case it goes wrong! Thanks While this is a solution, it doesn't completely solve my problem. Saving in the standard excel format that comes with Windows 7, when I try to open the file up. In these cases, open multiple Excel workbooks or spreadsheets in separate windows and maximize your view into your information. If you want to open a specific workbook in a new window, please right click this workbook tab, and then click Open In New Window in the list. Setting up your system to open Excel files in separate windows If you have Excel 2007 or Excel 2010, you can make a change on your system so that when you open an Excel file it will always open in a new Excel window. In technical terms, Excel uses.
I did find a way to do it by changing a fix. This tweak works with all Excel files, including files you open yourself and files that programs open via Excel. Why remove the ability to open windows for your application??? Or if you open two different instances of word as I described in my earlier post and then go to the Windows Task Manager you see two different applications for Word running, but only one for Excel. Would you like to answer one of these instead? Why Excel doesn't have native multi-monitor capability, beats me. If you're still using Microsoft Office 2003, and not Microsoft Office 2007, then your extension will be just xls.
Charles Peri is a programmer analyst with 20+ years of programming and database development experience. I inserted the picture more for a general reference to all the excel options as well as to show the sub-menu which exists within these excel folders. The changes below have worked on Windows 7 and Windows 8. This guide shows you how to do exactly that. How can I make Excel so that when I double-click a document, it opens in a new Excel instance, so that I can easily view them side-by-side as separate windows and not using the View-Arrange All functionality? They were slightly different in their instructions and a little hard to follow. I have Windows 7, 64-bit if that makes a difference. Right click on the regedit.
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. In my tests, the order in which you open the file types make a big difference! Once we covered But there is another, presumably non-standard, task that appears to be very popular - to open your Excel 2016 or 2013 spreadsheets in different windows. There should be an easier way. I don't think there is. The only drawback that made me change it back is that you can't establish any kind of link between the two windows. That is very annoying and the only way to open the files is to start excel, or use openoffice.
Changes to make in the Registry Warning: The steps below outline manual changes to be done on your Windows registry. When the key is created, double click on Default to give it a default value. Give the key any name you like. Basically I need a way to open a file directly in a new window. More proof mean people suck. One of them is selecting the in Advanced Excel Options.