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.