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

"Contacting the server for information" and "upload blocked" in Office365 WORD

This has been a frequent seen issue in our environment. The common symptoms are:  After a Word or Excel file open, or when trying to save...