in zssdemo,
in any cell it's formula contains sheet name, said B1 : '=Input!F7'
if I rename Input to XYZ,
select B1, the formula is still '=Input!F7' (should be '=XYZ!F7'
update value F7. the value of B1 is changed, and the formula become correct.