Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / September 2007

Tip: Looking for answers? Try searching our database.

Opening Excel '97

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
HiDbLevel - 19 Sep 2007 16:12 GMT
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 - 19 Sep 2007 18:48 GMT
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.

> 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
[quoted text clipped - 3 lines]
> on the file and have it open a new window automatically.  Any thoughts out
> there?

Signature

Dave Peterson

HiDbLevel - 19 Sep 2007 19:26 GMT
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.

> xl2k was the first version to offer Tools|Options|view tab|windows in taskbar.
>
[quoted text clipped - 34 lines]
> > on the file and have it open a new window automatically.  Any thoughts out
> > there?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.