Same workbook. I've closed Excel, rebooted, if I then open Excel and type
the number "1" in cell A1, then type "=A1+1" in cell A2, then select cell A2,
copy, paste in A3, it should copy the formula and give me the number 3,
however, it doesn't copy the formula, it just copies the number 2 from A2.
The formula bar at the top shows that the formula didn't copy. It's driving
me crazy. I can grab the plus in the lower right of the cell and drag it
down to copy the formula, but I cannot copy and paste it.

"Gord Dibben" wrote:

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.