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