excel self total

[MHPCAS via OfficeKB.com]

I have an existing form on my computer that will not self total the only
way it will total is if I hit at sum again and highlight numbers I want to
total. If I change these numbers it will not change my total until i hit at
sum and highlight it again. what is turned off in this form? any new forms
i make it self totals when i change the numbers. Help

 

[Norman Jones]

Hi MHPCAS,

Try:

Tools | Options | Calculation | Check Automatic

 

[Guest]

check to be sure that Automatic is checked under Tools>Options>Calculation

 

[MHPCAS via OfficeKB.com]

Now I feel really dumb I never thought to check that. I have been 4 months
fighting with this one form. Thank you very much.