software

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?

To set the maximum number of times Microsoft Excel will recalculate, type
the number of iterations in the Maximum iterations box. The higher the number
of iterations, the more time Excel needs to calculate a worksheet.

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

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 quot;upquot;,
then quot;upquot; 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 quot;dnquot; to quot;upquot; (where
columns 1 amp; 2 already had quot;upquot; in them, column 3 should have changed). some
kind of update problem cannot figure out. thanks.

quot;nastechquot; wrote:

gt; Looking for tha optimal settings for the following. Do not see a reset.
gt; Thanks.
gt; Tools, Options, Calculations:
gt; - Max. Iterations: ?
gt; - Max. Changes: ?
gt;
gt; I see the following in Help, but do not know if there are required min/max
gt; settings, normal settings?
gt;
gt; 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.
gt;
gt; maximum amount of change you will accept between calculation
gt; results. The smaller the number, the more accurate the result and the more time Excel needs to calculate a worksheet.

Please post your formula, input values, formula result.
BTW, did you check Toolsgt;Optionsgt;Calculation, Automatic?

--
Kind regards,

Niek Otten

quot;nastechquot; gt; wrote in message
...
gt; clarification, having problem with cells updating. don't know if I
gt; changed
gt; any settings, but: non-equation fields, e.g. if 2 columns both have
gt; quot;upquot;,
gt; then quot;upquot; in a 3rd column.
gt;
gt; the 3rd column will not change, unless double-clicking / putting cursor
gt; inside any one of 3 cells, then 3rd cell changes from quot;dnquot; to quot;upquot; (where
gt; columns 1 amp; 2 already had quot;upquot; in them, column 3 should have changed).
gt; some
gt; kind of update problem cannot figure out. thanks.
gt;
gt; quot;nastechquot; wrote:
gt;
gt;gt; Looking for tha optimal settings for the following. Do not see a reset.
gt;gt; Thanks.
gt;gt; Tools, Options, Calculations:
gt;gt; - Max. Iterations: ?
gt;gt; - Max. Changes: ?
gt;gt;
gt;gt; I see the following in Help, but do not know if there are required
gt;gt; min/max
gt;gt; settings, normal settings?
gt;gt;
gt;gt; maximum number of times Excel will recalculate, type the number of
gt;gt; iterations. The higher the number of iterations, the more time Excel
gt;gt; needs to calculate a worksheet.
gt;gt;
gt;gt; maximum amount of change you will accept between calculation
gt;gt; results. The smaller the number, the more accurate the result and the
gt;gt; more time Excel needs to calculate a worksheet.