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...