Thanks Amos. I think I've sorted it - somehow, and it wasn't me chosing it, Excel switched to manual calculation rather than automatic. I changed the option back to automatic and it works now. Still baffled though.