This question already has an answer here:
- Cells not updating automatically 6 answers
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?