Weird formula malfunction, has anyone seen this before?
 

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

Yeah I have had this quite a few times. It seems to be whenever someone is running large queries or the system is being used by more than usual (Network!). Also if your system memory is being hit hard. Its the same as when stuff doesn't update and you have to double click/F9 it and then it works itself out.

To be honest its relatively normal where I work as the system is not built to handle the amount of people that actually use it. Its also much more common on links to other sheets rather than internal sheet formulae, but that does happen to!

Weird formula malfunction, has anyone seen this before?
 

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 wrote:

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

Weird formula malfunction, has anyone seen this before?
 

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

"Dave Peterson" wrote:

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 wrote:

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