update cell without saving

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 ?

Tools|Options|calculation tab|

Make sure Automatic is checked.

philvis wrote:
>
> 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 ?
>
> --
> philvis
> ------------------------------------------------------------------------
> philvis's Profile: http://www.excelforum.com/member.php...o&userid=31433
> View this thread: http://www.excelforum.com/showthread...hreadid=511241

--

Dave Peterson

Yep, that was the problem. Thanks.