Monday, April 23, 2012

HOWTO Open Excel work paper in separate windows



If the work papers are in Engagement application, click on Tools/Options, check "Launch separate instance of Excel (Dual monitors).

This applies to Excel 2010 as well.

For Windows 7

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Right Click on Command – choose "rename" and add something to the name  - for example 2 (commend2).

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec:

Right Click on the folder ddeexec and choose "rename" and add something to the name  - for example 2 (ddeexec2)

Left column

HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/commend:

Right column {adding (space)"%1"}

Double Click on (Default) and write - "C:\Program Files\Microsoft Office\Office12\EXCEL.EXE" /e "%1"

Right Click on Command – choose "rename" and add something to the name  - for example 2 (commend2).

HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec:

Right Click on the folder ddeexec and choose "rename" and add something to the name - for example 2 (ddeexec2)

no restart needed

 

For Windows XP

1. In Windows Explorer, choose the Tools/Folder Options menu.
2. Click on the File Types tab
3. Scroll down and select the "XLS Microsoft Excel Worksheet" item
4. Click the "Advanced" button
5. Uncheck the "Browse in same window" option
6. Click on "Open" in the Actions list
7. Click the "Edit" button
8. Click in the "Application used to perform action:" box
9. Scroll to the very end. It will say something like ...EXCEL.EXE" /e %1
10. Put quotes around the %1, so it now ends with ...EXCEL.EXE" /e "%1"
11. Click OK twice, Close once, and you should be in business
12 Repeat the steps for XLSX.

 

No comments:

Post a Comment

Few issues after changed Office 365 subscription from E3 to Business Premium

After changed subscription from E3 - Office 2016 to Business Premium - Office 2013, I ran into all kinds of problems.  The first issue i...