mihel 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
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
The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Purch hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.