Exceel file showing read only in the library

sns 9,246 Reputation points
2022-07-19T18:31:04.597+00:00

User got contriubute acess to library but when he accessed file present in that library it is opening as read only, please see below screenshot "ReadOnlyFile"

222399-readonly.png222471-checkoutrequired.png

Where as I can see it as present in the screenshot as "checkout required"

THis user facing same issue with all excel files ad showing message as "ReadOnlyWorkBook"

Please suggest

Respective file is already discard check out is done, ut still the issue persists for that user alone.

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,145 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Renjie Sun-MSFT 2,846 Reputation points Microsoft Employee
    2022-07-20T03:42:09.683+00:00

    Hi @sns

    According to my research and testing, you need check out this excel file to make it able to be edit.
    The following steps show how to check out.
    First, select a file -> more -> check out.
    222496-image.png

    Then open this file, you are able to edit now.
    222553-image.png

    After checking out, no one else can edit this file. You need check in this file when you complete the edition. If anyone else need edit this file, he should check out this file in advance.

    If you don’t need this feature you could turn this off in library settings.
    The following steps show how to turn off check in/out feature.

    Library settings -> Versioning settings -> Require documents to be checked out before they can be edited? -> No
    222579-image.png

    More information for check in and check out:
    https://support.office.microsoft.com/en-us/article/check-out-check-in-or-discard-changes-to-files-in-a-sharepoint-library-7e2c12a9-a874-4393-9511-1378a700f6de?ui=en-US&rs=en-US&ad=US


    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.