Excel formulas

[Rolaxis]

When a formula is copied using the drag feature, the result in the new cells
remian the same as it is for the original cell. For example if the formula in
cell G34 is =f34*3 and the result of the formula is 120 and then that formula
is dragged to G35, the result is still 120, even though the result should be
something other than 120. This is happening on any worksheet, even after a
repair has benn done. The version of Excel is Office 2K3, Windows XP Pro is
the OS.

[Roger Govier]

Maybe Calculation is set to Manual?
Tools>Options>Calculation and select Automatic

--
Regards
Roger Govier
"Rolaxis" <[email protected]> wrote in message
news:[email protected]...
> When a formula is copied using the drag feature, the result in the new
> cells
> remian the same as it is for the original cell. For example if the formula
> in
> cell G34 is =f34*3 and the result of the formula is 120 and then that
> formula
> is dragged to G35, the result is still 120, even though the result should
> be
> something other than 120. This is happening on any worksheet, even after a
> repair has benn done. The version of Excel is Office 2K3, Windows XP Pro
> is
> the OS.