excel self total
 

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

Hi MHPCAS,

Try:

Tools | Options | Calculation | Check Automatic


---
Regards,
Norman



"MHPCAS via OfficeKB.com" wrote in message
...
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

check to be sure that Automatic is checked under ToolsOptionsCalculation

"MHPCAS via OfficeKB.com" wrote:

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

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.

--
Message posted via http://www.officekb.com