copy paste between two instances does not work

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
 
D

Dave Peterson

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.
 
D

Dave Peterson

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.
 
S

schouwla

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...
 
D

Dave Peterson

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...
 
Top