Let’s say I have a cell A1. I then write a formula in it that references cell B2. But now, I cut cell B2 to C3, and put new data into B2, either by copy-pasting or typing. I would expect A1 to update to reflect the new contents of B2, but that is not what happens. Instead, the formula in A1 has changed all references to B2 to C3. I can understand how this feature might be useful, but for me, now, it is definitely not, and I would like to turn it off. Is this possible?
EDIT: I initially said COPY-paste, which is very different from CUTTING and pasting.