i wonder is there's a fix to my problem doing summation and formula in excel not updating the total when a figure is changed. 1 troublesome solution i found is to edit formula and go to the formula line at the top and click enter but that way i'll have to do for every line which takes very very long time

Hi, 1. Please post the formula that is not updating.

2. Do you have Calculation set to manual - if so formulas will not recalculate when data changes.

3. If you click the f9 function key, do the formulas updateRegards.

thank you so much. it was your suggestion no 2 that fixed it. the calculation somehow previously set default to manual. thanks again

Ask Your Question

Weekly Poll