Nope. that's not it. But that is a great suggestion, I have also had
troubles with text formatting, just as you describe.

Anyone else have any ideas?

Thx

Dean
"Jakeman" wrote in message
oups.com...
A possibility...check the formatting of the cell that is not being
updated. I think I've seen this before when the cell is converted to
Text format and back to a numeric or general format.

Jake

Dean wrote:
I don't have any of this complicated functionality mentioned (such as
pivot
tables, manual calcs, etc) and there is no "calculate" message
showing
either.

Hasn't anyone else had this kind of problem? I've had it multiple
times, on
multiple computers.

Though you've told me how to fix it, assuming I know it exists, I'd
like to
know what is causing it.

Dean


"Tom Ogilvy" wrote in message
...
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