Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#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
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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 |