Exel 2003 Copy Formula Problem

  • Thread starter Thread starter addison
  • Start date Start date
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?
 
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?
 
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
 
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...
 
Back
Top