If you usually open spreadsheet through Windows Explorer, I found that the best option is to re-associate the extensions and specify your own command. If, after applying this file, you want to open another file in the same window, use the file menu to open another file and it will open in the current window.ĭisabling DDE seems like the best option, but as others have pointed out, that causes Excel to open a blank window when you try to open a spreadsheet through Windows Explorer. Windows Registry Editor Version Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /r Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" /r Files (x86)\\Microsoft Office\\Office14\\EXCEL.EXE\" \"%1\"" (You may want to back up your existing HKEY_CLASSES_ROOT\Excel.Sheet.12 and HKEY_CLASSES_ROOT\Excel.Sheet.8 branches (via regedit.exe's export) in case you want to revert this change. reg file with the following content into Window's registry (change the path to EXCEL.EXE according to the version and installation path you have and add any additional file types you want to remap ( Excel.Sheet.12 is for. Replace the value data with: "C:\Programįiles\Microsoft Office\OFFICE14\EXCEL.EXE" "%1" Double-click theĬommand string value, replace its data 1lfq?R& "%1"Īnother solution is to merge a.
Locate the registry subkey: HKEY_CLASSES_ROOT\Excel.Sheet.14\shell\Open.
Click Start, in the Search box, type regedit and press Enter.Sure that you follow these steps carefully. Might occur if you modify the registry incorrectly.
= Important This section, method, or task contains steps that tell you how to modify the registry. If this does not work,for Windows Vista and Windows 7, we need to edit Check the "Ignore other applications that useĭynamic Data Exchange (DDE)" box in Excel -> Excel Options -> Advanced To launch multiple instances of Excel, we change it by not using DDE
I have some data kept on Sheet 1 and some on Sheet 10 It is simple and extremely effective way of navigation Assume This Let me introduce you to something called as New Window.