getting a sum when hitting the enter key

[ironsides]

After putting in a formula like =sum(Y2-3) in the Z col, the result will not come up when after I enter a value in the Y col and hit enter, but it takes a SAVE to get the sum. How can I get it to total when hitting ENTER after putting the value in the Y col, instead of having to save? Thanx Ironsides

 

[nbrcrunch]

sounds as if you need to take a look at your calculation options.

menu: tools - options
tab: Calculation
option: Automatic.

 

[ironsides]

thank you. That sure duz it. Ironsides