Excel Clipboard Loosing Data?

S

sparvier

I found a very strange behaviour with Excel (both 2003 SP3 and 2000 SR-1).

If you copy and paste some data and formulas from an excel document to
another excel document belonging to THE SAME Excel INSTANCE, BOTH Data and
Formulas are copied.

This is the behaviour I would expect.

If you copy and paste data and formulas from an Excel document to another
Excel document belonging to a DIFFERENT Excel INSTANCE, FORMULAS are gone:
only values are copied!

It seems that the second Excel Instance doesn't see the first one and
"translates" the clipboard content to TEXT ONLY.

Is it "normal" or a is it a bug?

Thank you

Paolo Sparvieri
 
S

ShaneDevenshire

Hi,

This is Excel's behavior, but whether its intended or not, I don't know. If
you want the formula you can highlight it on the formula bar and copy it.
That's not much use for a large number of formulas, of course.
 

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

Linking data in MS Word into Excel 5
Pasting a cell into bookmarked table from excel vba 1
Style names lost when copy/pasting 6
Copy unformatted value of cell via macro 0
Excel 2007 freezes when copying formulas 1
Using Ctrl + Copy and Paste across multiple instances of Excel 0
Stop Excel from clearing clipboard? 1
Import data from excel 1

Top