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 ...
Well when they open it at the same time you will be able to see if someone is making changes and where their cursor is. But, you can also require check out for files in a SharePoint library and share the file from there. This might cause a bit of confusion as well however.
Other questions as well thou. Who will be accessing this data, external users? If so that will axe the check out idea :).
Other questions as well thou. Who will be accessing this data, external users? If so that will axe the check out idea :).
- I read it like he wanted to publish this online aka external anonymous users..
Check out is not an option here and also nothing prohibits people from erasing someone’s time and enter their preferred time instead! Overall it’s not a good solution...
Forms won’t let the people see other people’s booking times..
Bookings would be ideal here but I can’t really think of something else within Office 365 that would fit wellThe audience is internal users.
Yeah the problem with Forms is people won't be able to see slots that are already booked.
It's quite a large event with 4 simultaneous streams and I really would like to avoid lots of people emailing me individually, either to book slots or to report Excel issues :(
