Exel 2003 Copy Formula Problem

[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?

 

[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?

 

[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

 

[addison]

That was it!

Thank you!

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

 

[addison]

That was the problem!

Thank you!