View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
dbs dbs is offline
external usenet poster
 
Posts: 18
Default 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?