I have created a shared workbook on the network folder for about 20 users to go in and update information. I understand as long as users are NOT updating the same cell at the same time, it's fine.
However, recently users complain that they were being asked "which change wins? yours or other users'? " upon saving the workbook AND, they were not even updating the same records.
I noticed different users while in the shared workbook at the same time, were sorting the workbook differently. I am worried that because of this, they potentially will be wiping out other users' updates.
For example: I am updating information on row #2. Another user sorts it differently so row#2 on his/her screen is showing a different record. He/She updates it, then save. I try to save my updates on row #2 on my screen. Would a message pops out asking me which change I want to apply, Mine or the other user's? If I choose "mine", the other user's update will be wiped out, likewise if I choose "other user's", mine will be gone.
Is sorting a problem in a shared workbook? What alternatives do I have?
Thanks a lot!
Tonia
However, recently users complain that they were being asked "which change wins? yours or other users'? " upon saving the workbook AND, they were not even updating the same records.
I noticed different users while in the shared workbook at the same time, were sorting the workbook differently. I am worried that because of this, they potentially will be wiping out other users' updates.
For example: I am updating information on row #2. Another user sorts it differently so row#2 on his/her screen is showing a different record. He/She updates it, then save. I try to save my updates on row #2 on my screen. Would a message pops out asking me which change I want to apply, Mine or the other user's? If I choose "mine", the other user's update will be wiped out, likewise if I choose "other user's", mine will be gone.
Is sorting a problem in a shared workbook? What alternatives do I have?
Thanks a lot!
Tonia