当以编程方式更改引用的单元格时，链接不会更新

I have a cell A in one of the sheets referencing another cell B in another sheet. Links are set to updat autmatically. Everytime I change the value in Cell B, Cell A reflect the change as expected.I have a cell A in one of the sheets referencin