http://support.microsoft.com/default...b;en-us;243495
The Calculate message may remain in the status bar when you enter formulas
that include cell references


Other wise browse these articles:
http://tinyurl.com/65fjo

Check Charles Williams' site
http://www.decisionmodels.com



--



Regards,
Tom Ogilvy


"Dean" wrote in message
...
No, I'm not. No visual basic in this either. I have seen this kind of
instability several times, on different computers, over the years.

I appreciate the advice for a full recalc, but the danger is that one
doesn't think to hit full recalc after every change
and is susceptible to bad cells. The question is why it happens in the
first place. Do you know if it computer overload, EXCEL overload, or a
possible defective file?


Thx.
Dean
"Tom Ogilvy" wrote in message
...
Try Ctrl+Alt+F9

Are you using any User Defined Functions in the worksheet (functions
written
in VBA). Possibly one of them has bad error handling and causing the
calculation loop to be interrupted.

--
Regards,
Tom Ogilvy

"Dean" wrote in message
...
I had this happen before, usually with big EXCEL files. I change some
cells
and a cell that depends on them doesn't change. I have to go into the
cell,
take out the last character and put it back in, and then it updates.
hitting
F9 alone does nothing.

I am not on manual recalc or iterations. I forgot to try but I bet, if
I
saved the file and re-opened it, or closed EXCEL and reopen EXCEL, it
would
probably have fixed it too.

Does anyone know why this happens and if it is indicative of an
unstable
worksheet, or is it my computer being overloaded?

It's really scary! Thanks for your educated help!
Dean