Hey Dave -
Just thought I would put this in the support form because it took me SOO
long to find. But it did take care of this exact issue!!!
Here is a link to the website, but below are the steps:
http://myitkb.net/83/open-excel-2007-spreadsheets-in-different-windows.html
Open my computer
Click on Tools, then Folder Options
Select the File Types tab
scroll down to the XLS extension
select advanced
Select open
Select Edit…
in the line that says “Application used to perform action:†,
go to the end of the line and add “%1″
(that would be %1 within double quotes) so for example it may read something
like
“C:\Program Files\Microsoft Office\Office12\EXCEL.EXE†/e “%1″
uncheck Use DDE
Do not make any other changes
Click ok and click OK again
(note if you go back into advanced and back into the open action, you will
notice DDE is checked again, however the DDE message is blank; this is fine.)
Now scroll down to XLSX
repeat steps 5 through 11 above
Click on Close
Now, when you click on Microsoft Excel 2007 spreadsheets, they will open
separate windows for each Microsoft Excel 2007 spreadsheet that is launched.