Show Excel in two separate instances/two monitors?

[Ed]

I've recently been upgraded to two monitors (one of the few things IT
has done right around here!). But try as I might, I can't get two
Excel (2003) workbooks to show in two separate instances so I can put
one on each monitor! Any solutions?

Ed

 

[strive4peace]

Hi Ed,

open 2 workbooks -- click the Maximize button (so you are in resize
mode) --- drag a workbook by the titlebar to the second monitor...

Warm Regards,
Crystal
*
have an awesome day
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*

 

[Ed]

Hi, Crystal. I tried that, as well as New Window and a few other
things. Because there is only one instance of Excel (unlike Word
which opens every document in a new instance of the application), all
the workbooks follow each other around to whichever monitor I drag any
one workbook. Maybe I need a macro to open a workbook in a separate
application instance.

Ed

 

[Dave Peterson]

I don't use two monitors, but from what I've read from people who use multiple
monitors, you have to resize the application to cover both monitors.

Then open both workbooks
Then you can use window|arrange and resize the workbook windows so that each is
in one of the monitors.

By the way, MSWord may look like it's in two separate instances, but it's
actually one instance. If you open multiple documents in MSWord, you'll see
that they appear under the Window option on the menubar.

With tools|Options|view tab|windows in taskbar, you'll see multiple items in the
Applications tab, but only one process in the Processes tab.

 

[Ed]

I don't use two monitors, but from what I've read from people who use multiple
monitors, you have to resize the application to cover both monitors.

Oh, that's good, Dave! I like that huge screen! Finally I can see
every column!!

Then open both workbooks
Then you can use window|arrange and resize the workbook windows so that each is
in one of the monitors.

Got it - that works well. Thank you.

By the way, MSWord may look like it's in two separate instances, but it's
actually one instance. If you open multiple documents in MSWord, you'll see
that they appear under the Window option on the menubar.

With tools|Options|view tab|windows in taskbar, you'll see multiple items in the
Applications tab, but only one process in the Processes tab.

Okay - I'll take your word for it (no pun intended!). I'm not very
computer savvy when it gets deeper than what I see on my monitor. I
know the question bounces around the groups from time to time about
this, and I thought I understood it as separate application
instances. Maybe I only see multiple WINWORD.EXE when I crash my
macros!

Thanks for the boost, Dave.
Ed

 

[Bob I]

Click the Excel button in the Quick Launch bar TWO times.

 

[Ed]

Click the Excel button in the Quick Launch bar TWO times.

**D'oh!!**

Thank you, Bob. A perfect solution! (Which is probably why I
cuoldn't see it!)

Ed

 

[Bob I]

**D'oh!!**

Thank you, Bob. A perfect solution! (Which is probably why I
cuoldn't see it!)

Ed

You're perfectly welcome, enjoy! ;-)

 

[Dave Peterson]

You may find that having two instances of excel causes problems--especially when
trying to communicate between them.

Try copying a range with some formulas from one instance to another instance.

 

[Ed]

You may find that having two instances of excel causes problems--especially when
trying to communicate between them.

Try copying a range with some formulas from one instance to another instance.

Dave Peterson

I just tried that, Dave, and you're right. I had one workbook with
formulas and conditional formatting in one monitor, and opened a new
instance of Excel with a new workbook in the other monitor. I copied
a range form the first book and tried Paste Special in the second
book. It gave me a list of options like Workbook Object, Enhanced
Metafile, Bitmap, etc. rather than the list of Values, Formulas,
Formatting, Column Width, etc that I expected.

So I presume that I will need to generally stick with stretching the
one instance over two monitors, and might occasionally be able to use
the two instances (only because it's less of a pain to set up).

Thanks for your help.
Ed

 

[Dave Peterson]

That seems like a good solution--although separate instances would be very rare
for me.