Re: Reiterations / Changes Table Calculations..

Tech-Archive recommends: Fix windows errors by optimizing your registry

Please post your formula, input values, formula result.
BTW, did you check Tools>Options>Calculation, Automatic?

--
Kind regards,

Niek Otten

"nastech" <nastech@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:AF7C22C2-4433-406D-8802-5C895FFE4A42@xxxxxxxxxxxxxxxx
> 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 work***.
>>
>> 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 work***.


.

Quantcast