Excel references changing

[FinanceinTexas]

Has anyone ever had an issue where dragging and dropping, or even cutting and pasting a cell that contains a precedent to another cell doesn't cause the dependent cells to automatically update?

eg:
Cell A1: contains the value 5
Cell B1: contains a formula referencing cell A1, something like "=A1*2"

In most contexts and files, if I were to either cut and paste the cell A1 and move it anywhere else on this tab (or even on a different tab), the reference in B1 would automatically update to reference where this cell has been moved to.

However in some workbooks this is not happening. No clue why.

 

[Joe4]

I hate to say it, but you could have a corruption issue...

If it behaves unpredictably like that, and you do not have any VBA in the project, it is a real possibility.