formula only works when saved

[freelancer]

I have a spreadsheet that used to work fine, formulas would act properly and add/subtract/etc upon hitting enter. Suddenly when I enter data the formula does not compute when I hit the enter key - but it does compute when I hit the save icon, or close the file/save and re-open. I've been using Excel for quite some time and this is a new one on me. Is there a menu item that toggles formulas on & off in this way? Thanks

[martindwilson]

try tools /options/calculation make sure automatic is checked

[freelancer]

Wow! What a great community! I registered, posted a question, and received an answer within minutes!

Thanks Martin - I did not know that calculation tab was buried in that options menu. Awesome!

[martindwilson]

only hope it works!

[freelancer]

Yes, that was it. I have no idea how it changed, but there are others who use this spreadsheet so someone may have been poking around where they shouldn't have been. I guess it's time to enable protection!

[wiulmer]

Thank you for posting this question and the answer. I just started having this problem and the solution posted worked perfectly.

Thank you
Will