| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Match then lookup | Excel Worksheet Functions | |||
| Simple formula for newbie! | New Users to Excel | |||
| Programming a simple formula | New Users to Excel | |||
| simple interest formula in excel | Excel Discussion (Misc queries) | |||
| Need a simple formula please | Excel Worksheet Functions | |||
Linear Mode
