Excel Sort Bug?

[cgrablew]

When I was sorting a small workbook, I encountered an issue with sort treating relative references as absolute. If you put any value in cell A1, and a relative reference to A1 in cell B1 (=A1) then repeat this for a few rows, then sort, everything will sort properly. If you change the relative reference in B1... to have say =Sheet1!A1 and copy this down, then sort you'll find the absolute cell address remains in Column B so if the sort change the row position, column B will still have the absolute address you started with prior to the sort. Is this a bug? Why should putting the sheet name in the cell reference change the way the sort works?

 

[shg]

I don't know if the behavior is by design or pleasant happenstance, but that's the way it works.

 

[Jonmo1]

That is actually pretty cool...
Sometimes you want the formula's to sort, sometimes you don't.

I didn't know there was a choice...