Problem:
With Office 2003, Open xls (Excel) document in SAFE. Then open xls document outside of SAFE. If any one of the documents are closed by closing the application, the other document closes too.
Solution:
With Office 2003, Multiple xls(Excel) documents open in just one instance of Excel.exe. There by, if the excel application is closed, it in turn closes all the open documents. This does not work with SAFE as SAFE requires a separate instance of the application, as it monitors the closing of the application to save the document.
Method 1: (Rename enclosed file extension to .reg and run)
Windows Registry Editor Version 5.00
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open]
@="&Open"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\OFFICE11\\EXCEL.EXE\" /e \"%1\""
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec]
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\Application]
@="EXCEL"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\Topic]
@="System"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open]
@="&Open"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\command]
@="\"C:\\Program Files\\Microsoft Office\\OFFICE11\\EXCEL.EXE\" /e \"%1\""
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec]
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\Application]
@="EXCEL"
[HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open\ddeexec\Topic]
@="System"
Method 2: (Manual)
In Windows Explorer, Go to ToolsFolder OptionsFile Types
Scroll down to “XLS” extension. Click on “Advanced” button.
Select “Open” in the list and edit.
APPEND “%1” to the end of Application used to perform action
DELETE [open(“%1”)]
Scroll down to “XLS” extension. Click on “Advanced” button.
Select “Open” in the list and edit.
APPEND “%1” to the end of Application used to perform action
DELETE [open(“%1”)]
Comments
Please sign in to leave a comment.