I have this issue as well with a shared workbook and information
getting moved around when different users sort the data. We had to
set up a ground rule that sorting was not "allowed" when the workbook
is shared.

Is there a way around this?