update cell without saving

[philvis]

I have a real beginner question. I have an excel 97 spreadsheet that
won't update the results cell for a simple SUM function without saving
the spreadsheet. Can I change that ?

 

[Dave Peterson]

Tools|Options|calculation tab|

Make sure Automatic is checked.

 

[philvis]

Yep, that was the problem. Thanks.