Prevent multiple users from editing Excel at the same time

%3CLINGO-SUB%20id%3D%22lingo-sub-275413%22%20slang%3D%22en-US%22%3EPrevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275413%22%20slang%3D%22en-US%22%3EI%E2%80%99m%20trying%20to%20allow%20people%20to%20make%20appointment%20bookings%20online%20(and%20view%20which%20slots%20are%20available)%20but%20don%E2%80%99t%20have%20Microsoft%20Bookings%20enabled%20yet.%20The%20best%20I%20can%20think%20of%20is%20sharing%20an%20Excel%20workbook%20online%2C%20but%20I%E2%80%99d%20need%20to%20prevent%20multiple%20users%20from%20editing%20at%20the%20same%20time%20so%20they%20don%E2%80%99t%20overwrite%20each%20other%E2%80%99s%20appointments.%20How%20do%20i%20do%20this%2C%20or%20can%20anyone%20suggest%20a%20better%20way%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-275413%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275685%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275685%22%20slang%3D%22en-US%22%3EAgree%20with%20Adam.%20Excel%20online%20for%20everyone%20or%20even%20the%20client%20you%20can%20coauth%20is%20the%20same%20result%20as%20using%20planner.%20But%20if%20it%20works%20for%20you%20roll%20with%20it.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275650%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275650%22%20slang%3D%22en-US%22%3E%3CP%3EOK%2C%20if%20it's%20internal%20users%20i%20would%20probably%20just%20share%20the%20excel%20file%20and%20co-edit..People%20can%20see%20where%20others%20edit%20at%20the%20moment..It%20depends%20on%20your%20environment%20also..If%20you%20get%20problems%20with%20locked%20files%20and%20so%20on%20I%20would%20just%20go%20for%20the%20planner%20idea!%20%3A)%3C%2Fimg%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%2F%20Adam%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275595%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275595%22%20slang%3D%22en-US%22%3E%3CP%3EWAIT%2C%20I%20THINK%20I'VE%20FIGURED%20IT%20OUT!%20Not%20using%20Excel%2C%20but%20via%20Planner.%20Each%20bucket%20is%20a%20stream%20(I%20have%204%20simultaneous%20meeting%20streams)%2C%20each%20task%20within%20a%20bucket%20is%20a%20time%20slot%2C%20and%20participants%20can%20assign%20a%20task%20(timeslot)%20to%20themselves.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhat%20do%20you%20think%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275584%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275584%22%20slang%3D%22en-US%22%3E%3CP%3EThe%20audience%20is%20internal%20users.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYeah%20the%20problem%20with%20Forms%20is%20people%20won't%20be%20able%20to%20see%20slots%20that%20are%20already%20booked.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt's%20quite%20a%20large%20event%20with%204%20simultaneous%20streams%20and%20I%20really%20would%20like%20to%20avoid%20lots%20of%20people%20emailing%20me%20individually%2C%20either%20to%20book%20slots%20or%20to%20report%20Excel%20issues%20%3A(%3C%2Fimg%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275583%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275583%22%20slang%3D%22en-US%22%3E%3CP%3EI%20was%20thinking%20of%20putting%20the%20Excel%20file%20on%20SharePoint%20and%20sharing%20an%20edit%20link.%20I%20tested%20it%20with%20a%20few%20people%20and%20it%20seemed%20to%20work%20at%20first%20(user%20opened%20it%20with%20Excel%20i%20think%2C%20and%20received%20notification%20that%20the%20file%20was%20locked%20for%20editing%20by%20me)%2C%20but%20did%20not%20work%20with%20others%20(user%20opened%20with%20Excel%20Online%20and%20was%20able%20to%20edit%20it).%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275445%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275445%22%20slang%3D%22en-US%22%3EI%20read%20it%20like%20he%20wanted%20to%20publish%20this%20online%20aka%20external%20anonymous%20users..%3CBR%20%2F%3ECheck%20out%20is%20not%20an%20option%20here%20and%20also%20nothing%20prohibits%20people%20from%20erasing%20someone%E2%80%99s%20time%20and%20enter%20their%20preferred%20time%20instead!%20Overall%20it%E2%80%99s%20not%20a%20good%20solution...%3CBR%20%2F%3EForms%20won%E2%80%99t%20let%20the%20people%20see%20other%20people%E2%80%99s%20booking%20times..%3CBR%20%2F%3EBookings%20would%20be%20ideal%20here%20but%20I%20can%E2%80%99t%20really%20think%20of%20something%20else%20within%20Office%20365%20that%20would%20fit%20well%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275439%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275439%22%20slang%3D%22en-US%22%3EWell%20when%20they%20open%20it%20at%20the%20same%20time%20you%20will%20be%20able%20to%20see%20if%20someone%20is%20making%20changes%20and%20where%20their%20cursor%20is.%20But%2C%20you%20can%20also%20require%20check%20out%20for%20files%20in%20a%20SharePoint%20library%20and%20share%20the%20file%20from%20there.%20This%20might%20cause%20a%20bit%20of%20confusion%20as%20well%20however.%3CBR%20%2F%3E%3CBR%20%2F%3EOther%20questions%20as%20well%20thou.%20Who%20will%20be%20accessing%20this%20data%2C%20external%20users%3F%20If%20so%20that%20will%20axe%20the%20check%20out%20idea%20%3A).%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275429%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275429%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20it's%20not%20that%20urgent%2C%20Microsoft%20is%20currently%20looking%20into%20a%20similar%20feature%20that%20will%20be%20available%20for%20all%20Exchange%20Online%20users%2C%20but%20will%20probably%20take%20few%20months%20to%20be%20released.%20Otherwise%2C%20Bookings%20is%20a%20good%20alternative%2C%20or%20you%20can%20create%20a%20custom%20Form%20for%20people%20to%20fill%20in.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-275424%22%20slang%3D%22en-US%22%3ERe%3A%20Prevent%20multiple%20users%20from%20editing%20Excel%20at%20the%20same%20time%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-275424%22%20slang%3D%22en-US%22%3EWill%20you%20share%20a%20edit%20link%20on%20a%20website%20or%20what%20do%20you%20have%20in%20mind%3F%3CBR%20%2F%3EI%20don%E2%80%99t%20think%20it%20will%20be%20a%20good%20solution%20either%20way!%3CBR%20%2F%3EI%E2%80%99ll%20think%20about%20it%3C%2FLINGO-BODY%3E
Occasional Contributor
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?
9 Replies
Will you share a edit link on a website or what do you have in mind?
I don’t think it will be a good solution either way!
I’ll think about it

If it's not that urgent, Microsoft is currently looking into a similar feature that will be available for all Exchange Online users, but will probably take few months to be released. Otherwise, Bookings is a good alternative, or you can create a custom Form for people to fill in.

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 :).

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 well

I was thinking of putting the Excel file on SharePoint and sharing an edit link. I tested it with a few people and it seemed to work at first (user opened it with Excel i think, and received notification that the file was locked for editing by me), but did not work with others (user opened with Excel Online and was able to edit it).

The 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 :(

WAIT, I THINK I'VE FIGURED IT OUT! Not using Excel, but via Planner. Each bucket is a stream (I have 4 simultaneous meeting streams), each task within a bucket is a time slot, and participants can assign a task (timeslot) to themselves.

 

What do you think?

OK, if it's internal users i would probably just share the excel file and co-edit..People can see where others edit at the moment..It depends on your environment also..If you get problems with locked files and so on I would just go for the planner idea! :)

 

/ Adam

Agree with Adam. Excel online for everyone or even the client you can coauth is the same result as using planner. But if it works for you roll with it.