Sorting data in a shared workbook
 

I have a macro that sorts some data. It works fine, but after saving my
workbook, others open the workbook and discover than the data is not sorted
correctly in their workbooks. It seems to be an issue with Excel being
unable to recognize that cells need to be updated since they were actually
just rearranged, rather than modified. Any suggestions on how to get Excel
to update all of the sorted data when someone else opens a copy of the shared
workbook?