Exel 2003 Copy Formula Problem

A

addison

I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?
 
R

RagDyeR

Check if your calc mode is set to Auto.

<Tools> <Options> <Calculation> tab,

And make sure Auto is checked.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I have used Exel for years and never experienced this issue. I am trying to
simply copy (drag) a formula from one cell down the column and it will only
copy the value that the original cells sum equals. Not the formula itself.
Format for cells is set as number.

Any suggestions?
 
G

Gord Dibben

I think it is probably copying the formula but sounds like calculation is set to
manual.

Tools>Options>Calculation>Automatic.


Gord Dibben MS Excel MVP
 
A

addison

That was it!

Thank you!

Gord Dibben said:
I think it is probably copying the formula but sounds like calculation is set to
manual.

Tools>Options>Calculation>Automatic.


Gord Dibben MS Excel MVP
Click to expand...
 
Top