It may be a bug in my copy, but sometimes in excel I reference a cell in the normal way e.g. in cell a1 i type =f11 and the value gives me whatever is in f11. OK correct.
If I then change that to =f12 it just says =f12 in the cell !!! If I change it back to =f11 it now says =f11. No matter what I try it doesn't go back to just showing the value of the referenced cell.
Anybody experienced the same?!
If I then change that to =f12 it just says =f12 in the cell !!! If I change it back to =f11 it now says =f11. No matter what I try it doesn't go back to just showing the value of the referenced cell.
Anybody experienced the same?!