Press F9 to force Calculation. Set calculation to automatic.

Tools|Options|Calculation|Automatic

HTH,
Paul

--

"Harry" wrote in message
...
When I use handle to go down to next cell the formula changes like it
should
but the number stays the same as the cell I pulled down. Why?