does the formula recalculate when you press F9

have a look at <tools><options><calculation>
is it on manual?

This may have been caused by a previous book opened and saved with the setting on manual.