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.

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

HTH
Michael M

"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.

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?

"Michael M" wrote:

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

HTH
Michael M

"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.

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.

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

--
Stan Brown, Oak Road Systems, Tompkins County, New York, USA
http://OakRoadSystems.com/

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.

"spence" wrote:

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?

"Michael M" wrote:

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

HTH
Michael M

"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.