This made one of the worst days at the office even bad, please help!
I couldn't work out why my cells are not recalcualting.
I checked Tools > Options - Calculations and this is set to automatic.
However if I click into a cell or press F2 and then Enter this seems the only way the cell will...