copy paste between two instances does not work

  • Thread starter Thread starter schouwla
  • Start date Start date
S

schouwla

Dear Excel experts,

Sometimes when I copy cells from one Excel to the next the formulas
get's lost.


I select some cells contain some formulas and press copy in on
worksheet in one Excel session.
I select past in another worksheet in another Excel session.
Only values are copied over but the formulas are lost!


Regards
Lars Schouw
 
Don't open the workbooks in separate instances of excel--open each workbook in a
single instance of excel.

Open the first anyway you want, then use File|open to open the second.
 
I don't think it's a bug. One instance of excel doesn't know about the second
instance--so you're really going through the windows clipboard--instead of
excel's.
 
Why is that a problem?
Lars

Dave said:
I don't think it's a bug. One instance of excel doesn't know about the second
instance--so you're really going through the windows clipboard--instead of
excel's.
Click to expand...
 
If you want to see the other paste special menu, then it's a problem.

If you like to see the values, then it's not a problem.



Why is that a problem?
Lars
Click to expand...
 

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

Formula lost by copy paste from one Excel session to the next 3
copy and paste 4
I can't copy and paste equations 0
Why paste between workshhets yields values only 6
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Wierd Copy and Paste 3
Corrupt excel - copy paste between instances 3
unable to copy cell reference 6

Back
Top