Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM formulas exhibiting erratic behavior
I'm using Excel 2003, and have been making reports that use a lot of SUM and
SUM IF formulas. For some reason the formulas have stopped working, even though when I click on the destination cell, the formula is correctly expressed in the address bar. If I re-enter the formula, it does what it's supposed to, but only that one time. If I come back and add or delete data in the series, nothing changes in the destination cell. Some of these formulas are simply adding numbers in a column, but some express results in graphs that pull data from different worksheets. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM formulas exhibiting erratic behavior
Check Tools - Options -Calculation and see if calculation is set to manual.
Change it to automatic. HTH, Barb Reinhardt "Mango" wrote: I'm using Excel 2003, and have been making reports that use a lot of SUM and SUM IF formulas. For some reason the formulas have stopped working, even though when I click on the destination cell, the formula is correctly expressed in the address bar. If I re-enter the formula, it does what it's supposed to, but only that one time. If I come back and add or delete data in the series, nothing changes in the destination cell. Some of these formulas are simply adding numbers in a column, but some express results in graphs that pull data from different worksheets. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM formulas exhibiting erratic behavior
Check and make sure calculation is set to automatic.
ToolsOptionsCalculation Biff "Mango" wrote in message ... I'm using Excel 2003, and have been making reports that use a lot of SUM and SUM IF formulas. For some reason the formulas have stopped working, even though when I click on the destination cell, the formula is correctly expressed in the address bar. If I re-enter the formula, it does what it's supposed to, but only that one time. If I come back and add or delete data in the series, nothing changes in the destination cell. Some of these formulas are simply adding numbers in a column, but some express results in graphs that pull data from different worksheets. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
SUM formulas exhibiting erratic behavior
That was it! Thank you. I don't know how it got switched from automatic to
manual. I did copy the workbook to make a template for a new one, but it had worked fine for a while after that, so who knows. At least now I know it's a simple fix if it happens again. -M "Barb Reinhardt" wrote: Check Tools - Options -Calculation and see if calculation is set to manual. Change it to automatic. HTH, Barb Reinhardt "Mango" wrote: I'm using Excel 2003, and have been making reports that use a lot of SUM and SUM IF formulas. For some reason the formulas have stopped working, even though when I click on the destination cell, the formula is correctly expressed in the address bar. If I re-enter the formula, it does what it's supposed to, but only that one time. If I come back and add or delete data in the series, nothing changes in the destination cell. Some of these formulas are simply adding numbers in a column, but some express results in graphs that pull data from different worksheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Very odd behavior | Excel Discussion (Misc queries) | |||
Odd VLookup behavior | Excel Discussion (Misc queries) | |||
Strange behavior | Setting up and Configuration of Excel | |||
Unexpected behavior | Excel Discussion (Misc queries) | |||
Erratic Cursor Behavior | Excel Discussion (Misc queries) |