Jim T. sends this along, and I’m not sure what’s causing this behavior. Maybe you know and comment on it.
Col. D and Col. E are identical except that Col. E’s formula has range references that include the sheet name.
If you sort Col. D without sorting any other data on the sheet, you get the expected result (at least the result that I expect). That is, nothing happens. The formulas move to a different location and their range references change relatively. The formula that references A2, moves to D11 and then references A11. It looks like nothing happened.
Why then when I sort Col. E, does the same thing not happen? It sorts based on the values, but the formulas don’t change. Or maybe they do change – however you want to look at it.