Not able to calculate.

[Kquinn]

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?

 

[Myrna Larson]

Is calculation set to manual? Press F9 to recalculate. If that corrects the
problem, go to Tools/Options/Calculation and be sure it's set to Automatic.

 

[mark_kramarczyk]

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???

 

[rsorelle]

Has anyone offered a solution to this problem?