excel formula not updating total

Microsoft Windows 7 home premium
July 17, 2010 at 01:37:37
Specs: Windows Vista
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

See More: excel formula not updating total

Report •

July 17, 2010 at 07:23:36

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 update


Report •

July 18, 2010 at 02:39:53
thank you so much. it was your suggestion no 2 that fixed it. the calculation somehow previously set default to manual. thanks again

Report •

Related Solutions

Ask Question