For some reason all of a sudden when I update cells in Excel, my equations are not being updated. For example, I have a simple equation =SUM(C4:C16). If I change any of the cells in C4-C16, the answer doesn't get updated... I don't know what happened I've never seen this fail before. Any ideas?
| |||
|
feedback
|
|
Check to make sure Automatic Calculation is still selected. Go to Formulas->Calculation->Calculation Options and select "Automatic". | |||
|
feedback
|
|
I think this can happen when you end up with different data types in the fields in the given range. Can you check and make sure the data in there is all still numerical? I think I've noticed this happening for me when I threw in a value once that was "$xyz" as opposed to "xyz" (I mean xyz to be some integer, of course). | |||
|
feedback
|