Scripting: Open Excel Sheets in Separate Windows

If you work in an environment similar to my previous position, then you would know how often you hear certain complaints after upgrading people to new applications or Operating Systems. Well one of those complaints came from individuals that we upgraded to Office 2010. They were use to the option of opening up Excel Spreadsheets in separate windows, but in Office 2010 you can’t do this by default you have to make a few tweaks. My fix was to create a little Batch script that would alter the Registry and allow this to be done. I hope you enjoy…..

Open Excel Sheets in Separate Windows

cd %~dp0
echo off
cls

ECHO ***** This batch script is not working. Please double-click on the REG
ECHO files themselves and answer Yes to pop-ups to manually set the new entries.
ECHO Click the [X] in the top-right corner to Exit.

pause

ECHO Close Excel if running... NO reboot is required by this script.
ECHO Pressing (Space) or another key will CHANGE Excel 2010 to open
ECHO files in separate windows. If you do NOT want this, click the close
ECHO [X] in the top-right Corner to close this window now.
ECHO Press [Space} to continue and answer YES to any pop up messages...

Pause

regedit /s "del_HK_classes_root-excelsheet8-shell-open.reg"
regedit /s "hk-classes_root-excelsheet8_shell_open-newwinhack.reg"
regedit /s "del_HK_classes_root-excelsheet12-shell-open.reg"
regedit /s "hk-classes_root-excelsheet12_shell_open-newwinhack.reg"

pause

cls

ECHO Excel 2010 will now open files in separate windows. If this IS what
ECHO you want, click the [X] in top-right corner to close this window now.
ECHO Pressing (space) or other keys will RESET Excel 2010 to its original
ECHO single-window mode.
ECHO Answer YES to any pop up messages...

Pause

regedit /s "del_HK_classes_root-excelsheet8-shell-open.reg"
regedit /s "hk-classes_root-excelsheet8_shell_open-original.reg"
regedit /s "del_HK_classes_root-excelsheet12-shell-open.reg"
regedit /s "hk-classes_root-excelsheet12_shell_open-original.reg"

exit

Registry Entries – Multi Window Excel Sheet

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s