Open two Excel workbooks in separate windows?

[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

 

[Dave Peterson]

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.

 

[Nigel M]

some people have
posted that by starting two separate instances of excel, it works ok.

If I open another file, I get both in the same instance. How do you
launch a second one?

 

[Dave Peterson]

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.

 

[Nigel M]

I can start another instance by clicking on my shortcut to excel on my desktop.

D'OH! Thank you.