At my job we use more excel spread sheets than I care to comment on. I have always used excel for various tasks but lately I have needed to learn it more. One thing I found really anoting is that you cannot open multiple windows with excel spread sheets. This makes transfering and comparing data in between the tough. So thanks to some vetern guys at my work, they showed me a little registry hack to get this working.
1. Go into REGEDIT
2. Navigate to the following key: “HKEY_CLASSES_ROOT\Excel.Sheet.12\shell\Open”
3. Next, Delete the value for the ddeexec (default) key: it should say something like [open(“%1”)]
4. Above that there is also a command key with some data that looks like this:
“command REG_MULTI_SZ vUpAVH%!!!!!!!!MKKSkEXCELFiles>tW{~$4Q]c@II=l2xaTO5 /e”
5. Delete this key
6. Right-click on the value “(by default)” and select modify
7. Add a space then “%1” (with the quotation marks) at the end of the line so that the data resembles:
“C:\Program Files\Microsoft Office\Office12\EXCEL.EXE” /e “%1”
8. Goto the “HKEY_CLASSES_ROOT\Excel.Sheet.8\Shell\Open” key and re4peat the process as above.
9. Reboot and you should now be able to open up lots of seperate excel windows.
