Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
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 |
#2
![]() |
|||
|
|||
![]()
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 |
#3
![]() |
|||
|
|||
![]()
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 |
#4
![]() |
|||
|
|||
![]()
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
quattro pro converter Excel 2003 | New Users to Excel | |||
How do I Autosum a running column total in excel? | Excel Worksheet Functions | |||
how do I set up a total amount automatically in excel | Excel Worksheet Functions | |||
Subtotal of Subtotal displays Grand Total in wrong row | Excel Worksheet Functions |