Open two Excel workbooks in separate windows?

  • Thread starter Thread starter Nigel M
  • Start date Start date
N

Nigel M

How do you open two Excel 2003 workbooks in separate windows? I've got
dual monitors, and I want one on each.

TIA
 
I don't use xl2003 and I don't use multiple monitors, but some people have
posted that by starting two separate instances of excel, it works ok.

But this is two instances of excel--not just two workbooks open in the same
instance.

There are tradeoffs. Copying between these two workbooks may not work like you
expect.
 
some people have
posted that by starting two separate instances of excel, it works ok.
Click to expand...

If I open another file, I get both in the same instance. How do you
launch a second one?
 
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.

====
But you can't use File|open to open the second workbook. This will open in that
instance.
 
Back
Top