Opening Excel '97

[Guest]

I have MS Excel '97 on my computer at work. I notice that when I open
multiple excel files the program just puts all of the files in one window. I
would prefer to have the files open up in individual windows. Is there a way
to tell Excel to open everything in a new window? I know that I can just
open up a new Excel window then open the file, but I would rather just click
on the file and have it open a new window automatically. Any thoughts out
there?

 

[Dave Peterson]

xl2k was the first version to offer Tools|Options|view tab|windows in taskbar.

It showed each window as a different icon on the taskbar--but all those windows
were in the same instance of excel.

If you wanted separate instances of excel for each workbook, this may work...

You can change this setting (xl2003 and below menu):
Tools|Options|General tab|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 fixed.)

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

Cannot find C:\my, then more "Cannot find ..." messages.

It's more trouble than it's worth (for me, anyway).

If I want a second instance of excel, I'll just use:
windows start button|run
excel
then file|Open to open my file.

But I rarely want separate instances of excel. It makes it more difficult to
copy|paste between workbooks.

 

[Guest]

I was afraid that '97 couldn't do this. I tried the Ignore Other
Applications, but as you thought, it didn't quite work.

Oh well.