I am having a similar problem where the workbook refuses to calculate.
The calculation is set to automatic, although I have tried to force it
with F9, but that doesn't work either. Even entering a new formula
such as, =Today(), returns 1/1/1900 instead of the current date. The
really strange part is that it is not repeatable. Some times the
workbook will calculate properly, and other times it won't.
Additionally, once I open a workbook that won't calculate any
additional workbooks I open won't calculate either. It has happened to
more than one workbook and at more than one computer, but I can't
reliably duplicate the problem. Does anyone have any experience
tracking down a problem like this???


--
mark_kramarczyk
------------------------------------------------------------------------
mark_kramarczyk's Profile: http://www.excelforum.com/member.php...o&userid=16811
View this thread: http://www.excelforum.com/showthread...hreadid=270157

Has anyone offered a solution to this problem?

"Kquinn" wrote:

On a worksheet that I have been using for some time, my formulas do now not
recongize new numbers. When I now enter a number that is within the formula
range the formual does not change. This seems to have happend all of a
sudden.

Any suggestions?