formulas quit calculating

[Guest]

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.

 

[Guest]

Hi
Go to Tools / Options / Calculation / and check the Automatic radio button

HTH
Michael M

 

[Guest]

Unforunately that isn't the problem. "Automatic" is already selected in Excel
at all my workstations and it doesn't solve the problem. I'm discovering as
the day goes on that the problem is larger that I first noticed. I'm dealing
with approximately 600 workbooks and I've thus far found the problem in about
50 of them. That problem is likely to grow as the day goes on. Is it possible
I have some sort of corruption?

 

[Gord Dibben]

Check out Tools>Options>Calculations.

Make sure you set for Automatic.

If already so, try this trick.

Select all cells and Edit>Replace

what: =
with: =

Replace all.


Gord Dibben MS Excel MVP

 

[Stan Brown]

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

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.

Tools | Options | Calculation | Automatic

 

[Guest]

BY any chance, are there any user defined functions in the workbook? If I
want to recalculate those, I need to copy and replace a value that's an input
to them each time.