Re: Show Excel in two separate instances/two monitors?

Tech-Archive recommends: Fix windows errors by optimizing your registry

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

.

Relevant Pages

  • Re: Show Excel in two separate instances/two monitors?
    ... Dave Peterson ... instance of Excel with a new workbook in the other monitor. ... a range form the first book and tried Paste Special in the second ...
    (microsoft.public.excel)
  • Re: Page display is abnormal
    ... I have a dual monitor and when I move files to the extended monitor, ... What it sounds like you've got is a full-screen workbook that's been positioned so that its right & lower sides are off the screen. ... |>> resolution to get this to be a normal workbook page with the options replaced ... |> Dave Peterson ...
    (microsoft.public.excel.misc)
  • Re: Save as from a list
    ... "Dave Peterson" wrote: ... Can i make it create the worksheets in ONE workbook (basically create the ... Dim myCell As Range ... Dim ErrorCtr As Long ...
    (microsoft.public.excel.misc)
  • Re: DAO Syntax Problem
    ... under the last record I copied to the workbook, after I've done that then I ... "Dave Peterson" wrote: ... Dim ActSheet As Worksheet ... Sub Copydata() ...
    (microsoft.public.excel.programming)
  • Re: DAO Syntax Problem
    ... drinese18 wrote: ... under the last record I copied to the workbook, after I've done that then I ... "Dave Peterson" wrote: ... Dim ActSheet As Worksheet ...
    (microsoft.public.excel.programming)