Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with summing formula updating Total...
I just purchased a new computer and it came with Office 2003 on it. I've
used XP and all previous versions of office, so I'm a little confused by what is happening. I have a excel document that I use to track the cash for our company. The formula looks something like this. In cell F1 it says =A1+B1-C1+D1-E1 Then lets say If F1 is returning 6 which is = 4+4-2+2-2 from the other cells. In the older versions of Excel if I were to chance any of the cells say B1 to 0 instead of leaving it at 4 my total in F1 should automatically update to 2. =4+0-2+2-2. But with 2003 when I try to change any of the cells within the chain the total doesn't update. I have to actually click on the cell (F1) push the F2 key to see the cells and then press enter in order for it to calculate it correctly. Is this some new feature that 2003 has? I have no idea why it would be considered helpful, because it creates far more work. Please Help! Thanks, |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with summing formula updating Total...
ToolsOptionsCalculation tab, check "Automatic"
-- Kind regards, Niek Otten Microsoft MVP - Excel "Dave" wrote in message ... |I just purchased a new computer and it came with Office 2003 on it. I've | used XP and all previous versions of office, so I'm a little confused by what | is happening. | | I have a excel document that I use to track the cash for our company. The | formula looks something like this. In cell F1 it says =A1+B1-C1+D1-E1 Then | lets say If F1 is returning 6 which is = 4+4-2+2-2 from the other cells. In | the older versions of Excel if I were to chance any of the cells say B1 to 0 | instead of leaving it at 4 my total in F1 should automatically update to 2. | =4+0-2+2-2. But with 2003 when I try to change any of the cells within the | chain the total doesn't update. I have to actually click on the cell (F1) | push the F2 key to see the cells and then press enter in order for it to | calculate it correctly. Is this some new feature that 2003 has? I have no | idea why it would be considered helpful, because it creates far more work. | | Please Help! | | Thanks, | |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Problem with summing formula updating Total...
THANKS!!!! Saved me a huge headache!!
"Niek Otten" wrote: ToolsOptionsCalculation tab, check "Automatic" -- Kind regards, Niek Otten Microsoft MVP - Excel "Dave" wrote in message ... |I just purchased a new computer and it came with Office 2003 on it. I've | used XP and all previous versions of office, so I'm a little confused by what | is happening. | | I have a excel document that I use to track the cash for our company. The | formula looks something like this. In cell F1 it says =A1+B1-C1+D1-E1 Then | lets say If F1 is returning 6 which is = 4+4-2+2-2 from the other cells. In | the older versions of Excel if I were to chance any of the cells say B1 to 0 | instead of leaving it at 4 my total in F1 should automatically update to 2. | =4+0-2+2-2. But with 2003 when I try to change any of the cells within the | chain the total doesn't update. I have to actually click on the cell (F1) | push the F2 key to see the cells and then press enter in order for it to | calculate it correctly. Is this some new feature that 2003 has? I have no | idea why it would be considered helpful, because it creates far more work. | | Please Help! | | Thanks, | |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find value in array | Excel Worksheet Functions | |||
Is it possible? | Excel Worksheet Functions | |||
Formula for running total | Excel Worksheet Functions | |||
Need a formula to add the total # each time it finds a name | Excel Discussion (Misc queries) | |||
Old Lotus Sub Total & Grand Total formula | Excel Discussion (Misc queries) |