Forum Discussion
Prevent multiple users from editing Excel at the same time
I’m trying to allow people to make appointment bookings online (and view which slots are available) but don’t have Microsoft Bookings enabled yet. The best I can think of is sharing an Excel workbook online, but I’d need to prevent multiple users from editing at the same time so they don’t overwrite each other’s appointments. How do i do this, or can anyone suggest a better way?
- There are a couple of ways I can think of... 1. Turn Check Out/Check In on in the library where the excel sheet will live. However, this will rely on users remembering to check the document back in after editing. 2. As multiple people can edit a document (co-authoring) and see who else is editing at the same time, maybe just user training would be enough to explain what users will see when others are editing the document at the same time.
It's a large event and I can almost guarantee there will be accidentally overwritten bookings and tears :D
