Filtering a shared worksheet
 

We have a log in our office, and in order to keep track of different details,
etc. I have the worksheet filtered, so that we can easily sort tasks by
status, date due, who is taking care of it, etc. I also shared the worksheet
so that more than one person could use it at a time.

Recently we realized that the cells are not necessarily staying in the right
place. I wanted to know if anyone had any suggestions why... I am guessing
that even though excel allowed me to share the worksheet, when more than one
person sorts the worksheet, it gets mixed up. Does that make sense?