Excel files in Sharepoint read only

Anhalter42 1 Reputation point
2021-03-22T10:51:41.337+00:00

Hi,

I have a little issue with our SharePoint Server (SP 2019 hosted on Win Server 2019): all Excel files are always opened in read only mode, whether I open them from any browser (Chrome, IE, Edge, Firefox) or directly via file explorer. The files have not set any write protection and after searching a solution for this problem for about 3 days now I am asking here for some help. If there are any ideas I would appreciate.

Thanks in advance!

SharePoint Server Management
SharePoint Server Management
SharePoint Server: A family of Microsoft on-premises document management and storage systems.Management: The act or process of organizing, handling, directing or controlling something.
2,818 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. JoyZ 18,046 Reputation points
    2021-03-23T03:19:01.197+00:00

    Hi @Anhalter42 ,

    Please check as follows:

    1. Antivirus programs may open potentially unsafe files as read-only.Check with your antivirus provider to learn how to adjust these settings. For convenient test, please temporarily turn off the antivirus software to check the result.
    2. If you have libraries with Checkout, Required, or Validation columns or metadata, or when Draft Item Security is set to either Only users who can edit or Only users who can approve items in Version Settings of the library, these items will be synchronized as read-only.
    3. If Office is not activated, or if your subscription has expired, you might be in read-only Reduced Functionality Mode. For information on how to Activate Office, see Unlicensed Product and activation errors in Office.
      80474-image.png
    4. Right-click the file and choose Properties. If the Read-only attribute is checked, uncheck it and select OK.
      80340-image.png

    More information:

    https://learn.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/files-open-as-read-only-and-cannot-check-in-or-out

    If an Answer is helpful, please click "Accept Answer" and upvote it.

    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.