I have a fairly large spreadsheet. I have a formula reference AB2097 (and some items from another tab. When i sort by rows (Excel 2007) that cell reference does not follow. AB2097 is now D2097 but the reference is still AB2097. I have tried locking the reference $AB$2097, that hasn't worked obviously

Any thoughts as to what I am missing