Weird formula malfunction, has anyone seen this before?

[Meenie]

I have Excel 2003
I have a number of different workbooks with forumulas in them. Today I was
entering info into one of them and they weren't averaging as they're supposed
to. The cells with the averages just remained blank although when I clicked
on the cell where the average should be, the formula was still there.
I discovered I had to double click on the cell so that the formula showed
there, then hit enter,and then the formula worked again. I had to do that all
the way down the column that the averages were supposed to show in. I've been
doing this spreadsheet for almost 2 years now and never had this happen.
BUT THERE'S MORE... Later I opened another spreadsheet and had the same
problem. So I started going through my spreadsheets and I saw it in several
places. Some were linked to other workbooks, some were not.
It's very weird.
The information that was already in the spreadsheets wasn't affected, only
new info being entered.
Am I missing something here? Has anyone else ever experienced this?
Thanks, Meenie

 

[Dave Peterson]

Try
Tools|Option|Calculation tab
check Automatic.

This is an application setting that excel picks up from the first workbook
opened in that session.

 

[Meenie]

Thanks Dave, I found that unchecked in some of them. Odd.