Open additional document in a new Excel window

[Fred Holmes]

Is there any way to open multiple workbooks in Excel 2000 and have
each workbook open in a new *Excel window*? MS Word 2000 does this,
by default, i.e., each new Word document file opened appears in a new
Word window.

Will newer versions of Excel do this?

I have two monitors running, and when each document file opens in a
new window, it is possible/easy to put one document on each monitor,
and have both visible in large size at the same time, and adjust each
of the windows individually.

One can "sort of" do this by spreading the one Excel window across
both monitors, and then reducing each file from full screen mode (or
whatever is called for a document rather than a window) but that is
not convenient since it spreads the Excel window borders with the
toolbars, etc. across both monitors, and my two monitors are not the
same size/resolution. Hence I need to adjust the window size on each
monitor.

TIA

Fred Holmes

 

[Jim Thomlinson]

Check out this link...

http://www.cpearson.com/excel/MultipleMonitors.aspx

 

[Shane Devenshire]

Hi,

One way is to open a new instance of Excel, then open the file from that copy.

Fair warning, you are using more memory when you do this which may become a
problem if you try to open too many files.

 

[Fred Holmes]

Not a useful link. It has the solution that I have already found to
be less than satisfactory. Chip Pearson is using a configuration
where the multiple monitors are all the same. I'd do that too if I
could find the physical/room desktop space to do it. I can't fit two
22" monitors side-by-side on my desk.

If Word does what I want, why not Excel? I know, two differnt teams
developed the two different applications, and came to two different
conclusions about what the consumer would like. Such is life.

Opening separate instances of the application (Excel) would be much
more convenient.

Many thanks for all you folks do. I know you can't create what isn't
provided for.

Fred Holmes

 

[Fred Holmes]

If this works as advertised, it's a definite "yes," but I don't find
or know what you mean by the "Yes button." I guess I should have
thought of trying this myself. That it's not necessary in MS Word
didn't lead me to think of it.

A real problem with the method suggested by Chip Pearson is that if
you simply close Excel, then work on other workbooks with the Excel
Window limited to one monitor, and then open (by double-clicking) one
of the workbooks that had been displayed on the additional monitor,
you get a situation where the workbook is displayed "off screen" and
you have to go through a time-consuming process to bring it back
on-screen. The workbook window remembers its "restored"
configuration, which is on my right-hand monitor, but the Excel window
doesen't extend there right now, and the "full" button isn't visible.

I have a full bank of memory = 4 GB, with max usage of 3 GB under a
32-bit OS. Workbooks are generally small, 100 KB or so.

Many thanks for your help.

Fred Holmes