How to open Excel files in separate windows in Windows 7
However, you can configure your computer to always open Excel files in separate windows. We recommend that you only use the method in this article when your computer has sufficient RAM.To have us configure your computer to open Excel files in different windows for you, go to the "Here's an easy fix" section. If you prefer to configure your computer to open Excel files in different windows yourself, go to the "Let me fix it myself" section.
Here's an easy fixTo fix this problem automatically, click the Download button. In the File Download dialog box, click Run or Open, and then follow the steps in the easy fix wizard.
- Because the change involves modifying registry keys, the easy fix solution will create a registry backup at your desktop
- This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
- If you’re not on the computer that has the problem, save the easy fix solution to a flash drive or a CD, and then run it on the computer that has the problem.
Let me fix it myselfEasy fix 50801
Press Win+R on your keyboard to start a Run command box, and then type regedit.exe, Enter, open the registry editor.
If you are prompted for an administrator password or for confirmation, type your password, or click Yes.
IMPORTANT: If you modify the registry keys incorrectly, serious problems may occur. Therefore, make sure that you carefully follow these steps.
Navigate to the registry key: HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open
Right-click the key, and then click Export. This step is to back up the registry key.
After you back up the key, follow these step:
- Change the value of the Open\command registry key.
To do this, expand Command, double-click the Default entry, and then change the value to the following (with the quotes):
Office 2010:"C:\Program Files\Microsoft Office\Office14\EXCEL.EXE" "%1"
Office 2007:"C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" "%1"
Then, double-click the command key, move the cursor to the end of the string, and then replace /dde with "%1". If you are using Office 2007, replace /e with "%1".
- Rename Open\ddeexec.
To do this, right-click ddeexec, click Rename, and then change it to a new name. For example, ddeexec2.
In the same way, repeat the above steps to back up and modify the HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open registry key.
Now check if you open Excel files in separate windows.
Your opinion is important to us! Do not hesitate to tell us what you think of this article using the comment field located at the bottom of the document. This will allow us to improve the content. Thank you in advance !
Article ID: 2636670 - Last Review: 08/05/2016 08:46:00 - Revision: 8.0
- kbinfo kbhowto kbstepbystep kbtypenonkb kbpubtypesc kbexpertisebeginner kbfixme KB2636670