how to open multiple Excel files in separate windows?
 

Currently, after I opened an Excel worksheet, if I click on another Excel
worksheet to open it, it will be open within the same windows or Excel
instance/container. I have gone through all the settings and cannot find any
way to change this default behavior. This is something we can set in Excel
2003 and I don't know why Microsoft is taking it away from us in Excel
2007?!?!?!?!

Right now, the only workaround is to go through Start--All
Programs--Microsoft Office to launch another instance of Excel. Then do
File--Open to open another worksheet in its own windows. This is VERY
cumbersome.

Does anyone know how to change this default behavior? Or we are stuck with it?

Any help or suggestion is very much appreciated.

how to open multiple Excel files in separate windows?
 

1) In Explorer go to Tools Folder Options.

2) Choose the File Types tab then find XLS (and then XLSX) under
Extensions. Highlight it and click the Advanced button.

3) Select Open then the Edit button.

4) Now in the Application used to perform action field go to the end and add
a space followed by "%1". Be sure to include the quotes. You also need to
unselect Use DDE. OK all of your changes. Now when you open multiple Excel
spreadsheets each will be a separate instance of the application so you can
move them to separate monitors. The downside is that youll use more of your
PC resources.

Unfortunately, this does not work well with SharePoint 2007.

"simon" wrote:

Currently, after I opened an Excel worksheet, if I click on another Excel
worksheet to open it, it will be open within the same windows or Excel
instance/container. I have gone through all the settings and cannot find any
way to change this default behavior. This is something we can set in Excel
2003 and I don't know why Microsoft is taking it away from us in Excel
2007?!?!?!?!

Right now, the only workaround is to go through Start--All
Programs--Microsoft Office to launch another instance of Excel. Then do
File--Open to open another worksheet in its own windows. This is VERY
cumbersome.

Does anyone know how to change this default behavior? Or we are stuck with it?

Any help or suggestion is very much appreciated.