Formula--rather simple one
 

The formula is adding and subtracting numbers across the rows. The problem
is that when "some" of the cells containing numbers that are included in the
formula are deleted, changed--the result of the formula does not change. For
instance, the number in cell BW is deleted and nothing happens. Is there
something wrong with the way this formula is set up? Could there be corrupt
data?
=+B10+SUM(C11:CJ11)-SUM(CL11:FE11)

--
Wanda Garner
Highmark Blue Shield

Formula--rather simple one
 

Press "F9"... does the value change now? If so, you have automatic
calculation turned off...

<Tools<Options
Click over to the "Calculation" tab
Check "Automatic"

Does that help?
--
Regards,
Dave


"WandaSG" wrote:

The formula is adding and subtracting numbers across the rows. The problem
is that when "some" of the cells containing numbers that are included in the
formula are deleted, changed--the result of the formula does not change. For
instance, the number in cell BW is deleted and nothing happens. Is there
something wrong with the way this formula is set up? Could there be corrupt
data?
=+B10+SUM(C11:CJ11)-SUM(CL11:FE11)

--
Wanda Garner
Highmark Blue Shield

Formula--rather simple one
 

I pressed F9, but nothing happened. The Automatic Calculation option was
selected. Hummm. Your response, however, was not an incorrect answer--it
just didn't fix this particular problem.

--
Wanda Garner
Highmark Blue Shield


"David Billigmeier" wrote:

Press "F9"... does the value change now? If so, you have automatic
calculation turned off...

<Tools<Options
Click over to the "Calculation" tab
Check "Automatic"

Does that help?
--
Regards,
Dave


"WandaSG" wrote:

The formula is adding and subtracting numbers across the rows. The problem
is that when "some" of the cells containing numbers that are included in the
formula are deleted, changed--the result of the formula does not change. For
instance, the number in cell BW is deleted and nothing happens. Is there
something wrong with the way this formula is set up? Could there be corrupt
data?
=+B10+SUM(C11:CJ11)-SUM(CL11:FE11)

--
Wanda Garner
Highmark Blue Shield

Formula--rather simple one
 

There is also a Macro in this file that runs when the file is opened. We did
try to "unprotect" and open without running though with no change. Here it
is...

Sub PROTECT()
ActiveSheet.Unprotect
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.PROTECT DrawingObjects:=True, Contents:=True, Scenarios _
:=True
End Sub

--
Wanda Garner
Highmark Blue Shield


"David Billigmeier" wrote:

Press "F9"... does the value change now? If so, you have automatic
calculation turned off...

<Tools<Options
Click over to the "Calculation" tab
Check "Automatic"

Does that help?
--
Regards,
Dave


"WandaSG" wrote:

The formula is adding and subtracting numbers across the rows. The problem
is that when "some" of the cells containing numbers that are included in the
formula are deleted, changed--the result of the formula does not change. For
instance, the number in cell BW is deleted and nothing happens. Is there
something wrong with the way this formula is set up? Could there be corrupt
data?
=+B10+SUM(C11:CJ11)-SUM(CL11:FE11)

--
Wanda Garner
Highmark Blue Shield

Formula--rather simple one
 

Forgive me if this sounds strange...but changing cell "BW"???? Is thie cell
you are changing within any of the ranges actually referenced by the
formula?


"WandaSG" wrote in message
...
There is also a Macro in this file that runs when the file is opened. We
did
try to "unprotect" and open without running though with no change. Here
it
is...

Sub PROTECT()
ActiveSheet.Unprotect
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.PROTECT DrawingObjects:=True, Contents:=True, Scenarios _
:=True
End Sub

--
Wanda Garner
Highmark Blue Shield


"David Billigmeier" wrote:

Press "F9"... does the value change now? If so, you have automatic
calculation turned off...

<Tools<Options
Click over to the "Calculation" tab
Check "Automatic"

Does that help?
--
Regards,
Dave


"WandaSG" wrote:

The formula is adding and subtracting numbers across the rows. The
problem
is that when "some" of the cells containing numbers that are included
in the
formula are deleted, changed--the result of the formula does not
change. For
instance, the number in cell BW is deleted and nothing happens. Is
there
something wrong with the way this formula is set up? Could there be
corrupt
data?
=+B10+SUM(C11:CJ11)-SUM(CL11:FE11)

--
Wanda Garner
Highmark Blue Shield

Formula--rather simple one
 

Yes, its way out there within C11:CJ11
--
Wanda Garner
Highmark Blue Shield


"Andrew Houghton" wrote:

Forgive me if this sounds strange...but changing cell "BW"???? Is thie cell
you are changing within any of the ranges actually referenced by the
formula?


"WandaSG" wrote in message
...
There is also a Macro in this file that runs when the file is opened. We
did
try to "unprotect" and open without running though with no change. Here
it
is...

Sub PROTECT()
ActiveSheet.Unprotect
Selection.Locked = True
Selection.FormulaHidden = False
ActiveSheet.PROTECT DrawingObjects:=True, Contents:=True, Scenarios _
:=True
End Sub

--
Wanda Garner
Highmark Blue Shield


"David Billigmeier" wrote:

Press "F9"... does the value change now? If so, you have automatic
calculation turned off...

<Tools<Options
Click over to the "Calculation" tab
Check "Automatic"

Does that help?
--
Regards,
Dave


"WandaSG" wrote:

The formula is adding and subtracting numbers across the rows. The
problem
is that when "some" of the cells containing numbers that are included
in the
formula are deleted, changed--the result of the formula does not
change. For
instance, the number in cell BW is deleted and nothing happens. Is
there
something wrong with the way this formula is set up? Could there be
corrupt
data?
=+B10+SUM(C11:CJ11)-SUM(CL11:FE11)

--
Wanda Garner
Highmark Blue Shield