Check out ToolsOptionsCalculations.

Make sure you set for Automatic.

If already so, try this trick.

Select all cells and EditReplace

what: =
with: =

Replace all.


Gord Dibben MS Excel MVP

On Mon, 7 May 2007 15:21:02 -0700, spence
wrote:

I just stumbled across a BIG problem with a number of spreadsheets: all their
formulas have stopped calculating. If I unprotect the sheets, put the cursor
at the end of the formula in a particular cell, and then hit "enter," the
formula calcuates, but only if I do this in each cell that contains a
formula. The behavior is occuring in multiple workbooks that have been fully
functional for many months and is happening across multiple spreadsheets.
This is about to cause a major billing disaster for me so any help would be
greatly appreciated. I'm using Excel 2003.