Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Formula lost by copy paste from one Excel session to the next

4 views
Skip to first unread message

scho...@yahoo.com

unread,
Jun 27, 2006, 1:01:30 AM6/27/06
to
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

Dave Peterson

unread,
Jun 27, 2006, 7:32:12 AM6/27/06
to
Make sure that both workbooks are open in the same instance of excel--it sounds
like you have two separaten instances of excel open.

Open the first workbook, then use File|Open to open the second.

--

Dave Peterson

scho...@yahoo.com

unread,
Jun 27, 2006, 11:31:28 PM6/27/06
to
David,
Yes, it works in one session. How about between two Excel sessions?
Lars

Dave Peterson

unread,
Jun 28, 2006, 7:26:46 AM6/28/06
to
When you're using two different instances of excel, you're going through the
windows clipboard--not excel's.

I've never seen it work the way you want between multiple instances.

--

Dave Peterson

0 new messages