Single user edit for excel in OneDrive

Occasional Visitor

One of the managers and I are currently working out of the same worksheet and I need to put in a single user edit so that when we are in it neither of us can edit it whilst the other is in so we do not end up losing our work. How can I set up a single user lock so that only the first person in the file can edit but once they come out a prompt will then appear on the 2nd users screen informing them that they are able to edit?

1 Reply


In general that's Check In / Check Out mechanism which easily could be applied to SharePoint documents library. Not sure about OneDrive (both for business and personal), the latest is considered as personal storage,