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.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Fred Holmes" wrote:

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