formulas quit calculating
 

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.

formulas quit calculating
 

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.

formulas quit calculating
 

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.

formulas quit calculating
 

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.

formulas quit calculating
 

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/

formulas quit calculating
 

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.