Sharepoint Library "Require Check Out" feature and OneDrive "Sync" are not compatible?

Said A 706 Reputation points
2022-09-28T13:56:15.827+00:00

Hello everyone,

I have noticed a weird behavior when I enable the "Require Check Out" feature under a Sharepoint library.

Situation A: "Require Check Out" feature enabled and the library is NOT "synced" with OneDrive

  • Check out on the web works fine and I am able to edit the files in the library save them and check in (all within the web interface)
  • I am able to open the files "in app" and the desktop application (word, excel...) would load and I will be able to see the the "Check out button" in the yellow bar or under "File - Info"

245538-image.png

245558-image.png

  • I can check out, edit and save the document. Finally, check in works fine. This situation is behaving as expected.

Situation B: "Require Check Out" feature enabled and the library is "SYNCED" with OneDrive

  • Check out on the web works fine and I am able to edit the files in the library save them and check in (all within the web interface)
  • But, here I enabled the "Sync" feature under the library by clicking sync under the document library.
  • This syncs the files and I have the accessible under my local computer;
  • The files are synced as read-only, which I assume is okay because the library requires check out. (the files have this little lock icon under status)
  • This issue in this situation is that if I open the files using "open in app" or if open them directly form my computer, I am no longer able to see the "Check out" button, neither as yellow bar nor under the "File - Info"
  • Instead I am faced with the following:
    245576-image.png
  • If I click "Edit Workbook" I get the following message:
    245585-image.png
  • I can edit the document but cannot save it, which is normal because it was never checked out:
    245540-image.png

TL;DR Sharepoint's "Require Check out" is not fully compatible with OneDrive sync, if you have the library synced to a local folder, the files show up as read only, the check out button is not showing up at all.

I would appreciate any input or instructions on how to make these two features work simultaneously.

Thank you!

Regards,

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,621 questions
OneDrive Management
OneDrive Management
OneDrive: A Microsoft file hosting and synchronization service.Management: The act or process of organizing, handling, directing or controlling something.
1,121 questions
{count} votes

Accepted answer
  1. Yi Lu_MSFT 17,456 Reputation points
    2022-09-29T09:25:59.08+00:00

    Hi @Said A
    Per my test, if we enable the feature of "require check out" in SharePoint, the files synced to OneDrive will all be locked:

    245928-image.png

    The reason could be the following:
    "When syncing libraries that require check out, or libraries with required columns or metadata, the files are synced as read-only. If you do make changes to these files, the changes will not be synced back to Office 365."

    Here is a similar issue for you to refer to:
    https://techcommunity.microsoft.com/t5/onedrive-for-business/read-only-padlock-icon-files-ofdb-17-3-6743-1212/m-p/38428#M952

    You could send feedback to Microsoft SharePoint Feedback so that this problem could be resolved one day.


    If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    3 people found this answer helpful.

1 additional answer

Sort by: Most helpful
  1. Teamser 0 Reputation points
    2024-03-21T15:55:27.8166667+00:00

    I found the solution.

    It works if you don't sync the file with OneDrive.

    You need to open the file from the website or File>Open>Websites - YourCompany.

    But first stop syncing the folder!