Opening multiple excel sessions

[sgreen]

Ho w do I configure my excel so that when double click a .xls file from
explorer it starts a brand new Excel session rather than adding it to
an existing session?

Reason I want to do this is that if I have multiple sheets open and
some are set to manual calc and others are set to auto calc the
calculation setting defaults to what ever it was on the first file
opened.
This is creating a problem when I open an auto calc file first then
open a manual calc after as the manual one starts calcing upon opening
it.

Can anyone help me with this?

 

[Dave Peterson]

I can start another instance by clicking on my shortcut to excel on my desktop.

I can also do it by:
windows start button|run|excel
and hit enter

If either of these fail to start a new instance, you can change a setting to see
if that helps.

Tools|Options|General|Ignore other applications (check it)

Be aware that one side effect of having this setting checked is sometimes you
can't open a file by double clicking on it in explorer. (toggle it back and
that should be reset.)

This shows up for workbooks that have spaces in their name or path:
c:\my documents\excel\testworkbook.xls
or
c:\test of workbook2.xls

cause trouble for me with this setting checked.

 

[sgreen]

Thx for the feedback, yes I can open seperate sessions by using either
the shortcut and or the start menu however I would like to be able to
do so by double clicking the file from Explorer.
I had tried the Ignore other apps. check box but as you said it simply
launched excel and didn't open the file and even though I have disabled
it I get all sorts or file not found errors when trying to open a file.