Please post your formula, input values, formula result.
BTW, did you check ToolsOptionsCalculation, Automatic?

--
Kind regards,

Niek Otten

"nastech" wrote in message
...
clarification, having problem with cells updating. don't know if I
changed
any settings, but: non-equation fields, e.g. if 2 columns both have
"up",
then "up" in a 3rd column.

the 3rd column will not change, unless double-clicking / putting cursor
inside any one of 3 cells, then 3rd cell changes from "dn" to "up" (where
columns 1 & 2 already had "up" in them, column 3 should have changed).
some
kind of update problem cannot figure out. thanks.

"nastech" wrote:

Looking for tha optimal settings for the following. Do not see a reset.
Thanks.
Tools, Options, Calculations:
- Max. Iterations: ?
- Max. Changes: ?

I see the following in Help, but do not know if there are required
min/max
settings, normal settings?

maximum number of times Excel will recalculate, type the number of
iterations. The higher the number of iterations, the more time Excel
needs to calculate a worksheet.

maximum amount of change you will accept between calculation
results. The smaller the number, the more accurate the result and the
more time Excel needs to calculate a worksheet.