You might want to copy your sheet to a new workbook since this might be a
sign that your workbook is getting corrupt.Nevertheless this has always
helped me when faced with a similar problem, select the range in question,
do editreplace and replace = with = (in the find what box type the equal
sign and in the replace with box type the equal sign)
That will force a recalculation



--
Regards,

Peo Sjoblom

"JDFitz" wrote in message
...
I have recently encountered the strangest thing in some of my Excel 2003
workbooks. The functions just stop working. I have a workbook with
multiple
sheets and an array of formulas that all stopped displaying the formula
results. It almost seems like the cells have become corrupt. The
formulas
are all correct as well. The only way I can get them to produce the
result
is to enter into the cell (double click or F2) and press the enter key
again.
MAGIC!!! the result displays. I cannot do this for thousands of cells and
multiple pages though. Even after I do, the formula will not update with
a
new results unless I follow the preceeding step again. It's like Excel
went
catatonic.

Has anyone else encountered this occurence? Is there a fix? Do I have to
rewrite my entire workbook?

Thanks in advance.

JD