I am copying within the same worksheet in the same workbook, and no cells are
hidden. Any ideas?

"Dave Peterson" wrote:

Are you pasting between different workbooks? Any chance that you don't have
both workbooks open in the same instance of excel?

Are you copying only the visible cells (like in a range that was filtered)--but
not the hidden rows?



Terry A-R wrote:

I recently upgraded to Excel 2003, and noticed that often when I copy and
paste cells, Excel pastes the value, not the formula. But it's very
inconsistent. If I copy a cell and then paste it multiple times in different
cells, after about the 3rd or 5th time it suddenly switches from pasting
formulas to pasting the original value. It's inconsistent as to when it
happens (sometimes even the first time I paste). I use ctl-c to copy and
ctl-v to paste. Any ideas?

--

Dave Peterson