There are no macros showing, but would this kind of thing be hidden somehow?

"Dave Peterson" wrote:

I'm not sure if any of the stuff in the clipboard would exist after a save (even
an autosave).

But maybe there's an event macro that is converting the formulas to values after
the paste???

Eric wrote:

Something else did occur to me -- what about your autosave feature?? If it
is set to save frequently, perhaps it is saving before your nth paste and is
eliminating your formula from the clipboard? Its kind of a long shot, but I
would at least take a gander at it.

"Terry A-R" wrote:

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


--

Dave Peterson