Are you copying and pasting within the same workbook or from one workbook to
another?

Possibly you have two instances of Excel running with a workbook in each
instance.

Close one insrance and open both workbooks in the single instance.


Gord Dibben MS Excel MVP

On Wed, 30 Sep 2009 01:36:01 -0700, steven
wrote:

I'm just copying one cell to another in Excel 2003, the cell I'm copying has
a formula, however only the data is getting copied, not the formula
(=B2+$A$2). I've used excel for over 10 years and never seen this problem,
I'm stumped. Usually I would use Paste Special to get this result, but Paste
Special doesn't even seem to have an option for pasting my formula. I'm
using CTRL+C & CTRL+V as always.