After recently installing Windows 7, I set up Office 2007 for work. However, having grown accustomed to Office 2010, I found it challenging to revert to an older version and decided to upgrade back to Office 2010. This led me into a dilemma. In my daily tasks, I often need to open multiple Excel files simultaneously; however, the default setting in Excel 2010 only allows one workbook per window when opened by double-clicking. This limitation was quite frustrating and inconvenient. After extensive searching online, I finally discovered a workaround that I'd like to share with everyone. Note: This method is applicable for both Windows 7 and Office 2010 versions.
-
Open the Registry Editor and first export your registry as a backup.
-
Navigate to [HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open], expand 'Open', delete 'ddeexec', then select 'command'. Double-click the default value in the right pane and change the end from /dde to "%1" (make sure you include the quotes). Next, double-click 'command' again and change its end from /dde also to "%1".
-
Then navigate to [HKEY_CLASSES_ROOT\Excel.Sheet.8\shell\Open] and modify it using the same method as above.
Once completed, I excitedly opened Excel again and was thrilled to see my familiar interface once more! Special thanks go out to the original author for their hard work!