

Office 2007, 2010, etc.), and is very easy to do plus I have provided screenshots to help you, so don’t be scared that you have to modify the registry to do this. This tweak takes less than five minutes, works on any computer (Windows XP, Vista, Win7, etc.) with Microsoft Office 2003 and higher (e.g. To force Microsoft Excel to open files in new window, you must do a registry tweak. How to force Microsoft Excel to open files in new window

This guide shows you how to do exactly that. Fortunately, there is a way to force Excel to open spreadsheets in new windows. Unfortunately, the default behavior of Microsoft Excel is to open spreadsheets in the same window. Rather, a best practice when working with multiple Excel spreadsheets at a time is to open the spreadsheets in separate windows, allowing you to easily tile the windows next to each other using WinSplit Revolution or, if you use multiple monitors, allowing you to place each window in its own monitor. However neither of these methods is very attractive if you use multiple monitors or if you like using window-resizer programs like WinSplit Revolution. You can, of course, use Alt + Tab to continually switch between the spreadsheets, or use Microsoft’s build-in secondary window function (you know, how you can minimize spreadsheets within the same window) to place the spreadsheets side by side. The three values you would want to set are:īy setting each value to 1 you will disable Protected View for that file location.Often times you may find yourself in a position where you are using two or more Excel spreadsheets at the same time. HKCU\Software\Microsoft\Office\14.0\PowerPoint\Security\ProtectedView HKCU\Software\Microsoft\Office\14.0\Excel\Security\ProtectedView HKCU\Software\Microsoft\Office\14.0\Word\Security\ProtectedView If for some reason the options in Office do not work or you want to be able to automate this setting for multiple computers you can try setting one or more of these registry values below. Like most options in Windows there is a way to disable these settings via the registry too. To add more locations that are marked as safe for Protected View go back to the Trust Center Settings and click Trusted locations on the left.Ĭlick add new locations at the bottom and browse to the location you would like to add to the trusted locations list.Īny documents in the new location will now be marked as safe. Repeat these steps for Microsoft Excel and Powerpoint if you want to disable Protected View there too. Once you check or un-check the settings you want you can close the windows.
