The formula calculates correctly when we first type it into the column. But
when we change a value in the formula it does not recalculate. What is wrong.
Tools|Options|Calculation is "Automatic" checked?
Jerry
> The formula calculates correctly when we first type it into the column. But
> when we change a value in the formula it does not recalculate. What is wrong.
lawgirl11 - 30 Jun 2006 23:37 GMT
Jerry
Thanks for the reply. This is excel at work and I will try what you say and
let you know as soon as I get back to work.
> Tools|Options|Calculation is "Automatic" checked?
>
> Jerry
>
> > The formula calculates correctly when we first type it into the column. But
> > when we change a value in the formula it does not recalculate. What is wrong.