When I go to some cells in my file and hit F2, then F9, it shows #NAME?, even though the value shown in the cell itself is clearly Ok, such as 15.4, as well as another cell which sums this cell with other cells (and doesn't exhibit the aforementioned f2, f9 problem)?.

What are the possible causes of this?