Copying between 2 instances of Excel.

J

John

I have recently added a 2nd monitor to my PC. In order to have a
spreadsheet open on each monitor, I have to run 2 instanced of Excel.
However, when copying from one instance to another, only values get
copied, not formulas. There is no warning when pasting.

Is this behaviour normal?
 
N

Nick Hodge

John

I can test it, but Excel stores it's own clipboard and I suspect this is per
instance, so when you take data outside, it drops the formula as it believes
it has no need for them. i.e. as if you were pasting into Word.

Not a positive reply, but my 'gut feel'

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top