Maybe you can explain what you're doing in more detail?

Are you copy|pasting
from and to the same worksheet?
From and to the same workbook?
or from and to different workbooks?

If you're working in two different workbooks, make sure you open both workbooks
in the same instance of excel.

Close excel (all instances)
Open the first workbook (anyway you want)
Open the second via File|Open (or ctrl-o)
and test.

NowWhatHaveIDone200 wrote:

I am having a strange phenomenon since I installed MS Office to an older
Windows XP system I have. Copying cells in Excel has become ahit or miss
proposition. I finally figured out that when I attempt to copy cells, for an
unknown reason, a large majority of the time it now copies the cells as
embedded objects. This happens for long periods of time making Exel
worthless and then mysteriously it goes away. I think this same situation is
affecting other programs. My theory is the MS Office install has somehow
damaged normal Windows XP processing of clipboard copies. 70% of the time
all copies are being copied as embedded objects. Does anyone have any
experience with something similar?

--

Dave Peterson