How to open an Excel file in a separate window

Source: Internet
Author: User

Failure phenomenon:

How do I open an Excel file in a separate window?


Solution:
A safer way to do this is to open the Excel program directly from the Start menu, and then use file-open in a new Excel program to open the file. is equal to opening a new Excel.exe process.
Excel20102007 opened the file in a window originally intended to save memory. However, if you have a lot of machine memory and want to change it once and for all, try this method.

Method One: Fixit automatic modification

Click the " resolve this issue " link to tap "Run" in the File Download dialog box, and then follow the wizard.

(Small hint: Because the modification involves registry modification, in order to avoid accidental or easy to restore later, the Fixit tool will create a registry backup on the desktop)

The tool is saved in the repository attachment.

Method Two: Manual modification
Use the shortcut key combination "win+r" to pull up the Run command box, type regedit.exe, enter, and open Registry Editor.





(if pop-up User Account Control window, please allow to continue)






Tip: Serious problems may occur if the registry is incorrectly modified. Therefore, make sure that you follow these steps carefully. To increase protection, please back up the registry before modifying it.

Navigate to the registry key value:Hkey_classes_rootexcel.sheet.12shellopen

Right-click and select Export . We'll make a backup of it before we change it.









after a good backup, you can make bold changes.


  1. Modify the opencommand value.

    Expand "Opencommand", in the right detail window:

    Double-click to open default and change its key value to "c:program filesmicrosoft OfficeOffice14EXCEL.EXE" "%1"

    (If you are using Office 2007, change Office 14 to office 12.) In addition, do not lose the quotation marks)






    Then, double-click the command, move the mouse cursor to the numeric data, and replace the /dde with "%1"

    (If you are using Office 2007, replace/e with "%1")




  2. Rename the openddeexec.

    Selectddeexec, right-click, and select rename . Take a new name for it, such as "ddeexec2".








    In the same way, the Hkey_classes_rootexcel.sheet.8shellopen are backed up and modified.



is it possible to open an Excel file in a separate window now?

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.