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

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 wrote:
> 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
>

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

On Mar 26, 6:13 pm, strive4peace <strive4peace2...@yahoo.com> wrote:
> 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 wrote:
> > 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- Hide quoted text -
>
> - Show quoted text -

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 wrote:
>
> 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
>
> On Mar 26, 6:13 pm, strive4peace <strive4peace2...@yahoo.com> wrote:
> > 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 wrote:
> > > 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- Hide quoted text -
> >
> > - Show quoted text -

--

Dave Peterson

On Mar 27, 8:14 am, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> 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

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

Ed wrote:

> 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
>
> On Mar 26, 6:13 pm, strive4peace <strive4peace2...@yahoo.com> wrote:
>
>>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 wrote:
>>
>>>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- Hide quoted text -
>>
>>- Show quoted text -
>
>
>

On Mar 27, 10:42 am, Bob I <bire...@yahoo.com> wrote:
> 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

Ed wrote:

> On Mar 27, 10:42 am, Bob I <bire...@yahoo.com> wrote:
>
>>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
>

You're perfectly welcome, enjoy! ;-)

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 wrote:
>
> On Mar 27, 10:42 am, Bob I <bire...@yahoo.com> wrote:
> > 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

--

Dave Peterson

On Mar 27, 3:35 pm, Dave Peterson <peter...@verizonXSPAM.net> wrote:
> 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