Windows XP (Office 2003,2007)
1. Open excel. Open ‘Tools-Options’. Select General tab.
- Check 'Ignore other applications' checkbox.
- Close Excel.
2. Open file-explorer. Open 'Tools-Folder Options’. Select File Types tab.
3. For XLS and CSV file types, perform the following.
- Highlight File type.
- Press Advanced Button
- Select the Open action and press Edit.
- Uncheck the 'Use DDE' Checkbox.
- In the Text Box, 'Application used to perform action', Add <space>"%1" to the end.
i.e.
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" /e "%1"
##############################################################################
Windows 7,10 ( Office2007 )
1. Open Excel. Open 'Excel Options-Advanced'.
- In General Options, UnCheck 'Ignore Other Applications that use DDE.
- Exit Excel
2. Update Registry.
- Run 'regedit'. Press Start-Run, Type Regedit
- Update the following registry key's
KEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command/default: add [space]"%1"
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/command/ Rename Command to Command_old
HKEY_CLASSES_ROOT/Excel.Sheet.8/shell/Open/ddeexec. Rename Keyname ddeexec to ddeexec_old
#############################################################################
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/default. Add [space]"%1"
HKEY_CLASSES_ROOT/Ecel.Sheet.12/shell/Open/command/ Rename Command to Command_old
HKEY_CLASSES_ROOT/Excel.Sheet.12/shell/Open/ddeexec. Rename Keyname ddeexec to ddeexec_old
##############################################################################
HKEY_CLASSES_ROOT/Excel.SheetMacroEnabled.12/shell/Open/default. Add [space]"%1"
HKEY_CLASSES_ROOT/Excel.SheetMacroEnabled.12/shell/Open/Rename Command to Command_old
HKEY_CLASSES_ROOT/Excel.SheetMacroEnabled.12/shell/Open/ddeexec. Rename Keyname ddeexec to ddeexec_old
##############################################################################
i.e.
"C:\Program Files\Microsoft Office\OFFICE12\EXCEL.EXE" /e
"C:\Program Files\Microsoft Office\OFFICE12\EXCEL.EXE" /e "%1"
