I have a shared workbook that we update daily. The only changes are in one column, where we add/edit comments relating to contract details provided in that row. The problem I am hearing about is that our CSRs are making a comment on Joe Smith's contract, but when they reopen the file tomorrow, Joe Smith shows no comment and the comment made now appears on a different contract.

I have a lot of experience in Excel, but I'm new to using Shared Workbooks. If 2 people have the workbook open at the same time, and both save changes, how does Excel know what and where to save?

I'm thinking that maybe what is happening, is CSR 1 is sorting the list by a different column, or in a different order, adding comments and saving, while CSR 2 already has the file open, has made changes then saves also. If Excel just says to itself, CSR 2 made changes in cells N23, N34 and N61 and applies those changes when he saves, those cells may not align correctly if CSR 1 sorted the whole list in a different order.

Is this what is causing our problems, or am I way off base? Please help!

Thanks!
John