Copying between 2 instances of Excel.

  • Thread starter Thread starter John
  • Start date Start date
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?
 
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
(e-mail address removed)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Two Instances 3
Corrupt excel - copy paste between instances 3
Copy paste between workbooks yields Value only 4
Can I open a new Excel document in a separate instance of Excel? 1
Excel - Dual Monitors - A trick that works 3
Excel TWO Instances of Excel One watching Other 3
pasting content copied from nonadajacent cells 1
Multiple Instances for Multiple Monitors... 4

Back
Top