When i copy(drag) a SUM: formula down from another cell, the values in the destination cells do not update yet the formula shown in the viewing bar that it should. However, when i F2 to look at the formula, they suddenly update when i leave the cell in question. Have i turned something off unwittingly?
Bookmarks