SingularitysPoint
New Member
- Joined
- Nov 20, 2015
- Messages
- 17
- Office Version
- 365
- Platform
- Windows
Hi.
I have a sheet that multiple people will work in to update a worklist. I've got around the issue of updates being 'posted' to a hidden sheet overwriting the same line if two people do it at the same, but I'm also getting it to save as part of the update code, so it's immediately available to everyone else. The problem I'm having is, if more than one person does the update simultaneously, they can't both save the sheet at the same time, so changes can be lost.
I've tried to put a loop in so, on error, it jumps back and tries to save again, but it still gives the can't save, changes will be lost message.
Does anyone have any ideas?
I have a sheet that multiple people will work in to update a worklist. I've got around the issue of updates being 'posted' to a hidden sheet overwriting the same line if two people do it at the same, but I'm also getting it to save as part of the update code, so it's immediately available to everyone else. The problem I'm having is, if more than one person does the update simultaneously, they can't both save the sheet at the same time, so changes can be lost.
I've tried to put a loop in so, on error, it jumps back and tries to save again, but it still gives the can't save, changes will be lost message.
Does anyone have any ideas?
