If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Excel 2003 - Problems with calculation
Some of our users experience problems with calculations in different excel
sheets. We use Windows XP and Office 2003SP2. Simple addition formulas are not working. When an addition cell is updated with a new number, the sum cell does not change to reflect the new calculation. Under Options, "Automatic Calculation" is ticked, and the cells are defined as figures. When the file is closed and opened again, the calculation is correct. The error is seldom seen. Thanks in advance for your assistance |
#2
|
|||
|
|||
Excel 2003 - Problems with calculation
I'd double check that tools|options|calculation tab setting.
But if that doesn't seem to help, maybe... Select all the cells edit|Replace what: = (equal sign) with: = replace all Excel will see that you've changed each formula and will recalculate again--and maybe wake up its calculation engine so that it recalcs correctly from now on. Roland wrote: Some of our users experience problems with calculations in different excel sheets. We use Windows XP and Office 2003SP2. Simple addition formulas are not working. When an addition cell is updated with a new number, the sum cell does not change to reflect the new calculation. Under Options, "Automatic Calculation" is ticked, and the cells are defined as figures. When the file is closed and opened again, the calculation is correct. The error is seldom seen. Thanks in advance for your assistance -- Dave Peterson |
Thread Tools | |
Display Modes | |
|
|