question

Anhalter42-1031 avatar image
0 Votes"
Anhalter42-1031 asked JoyZ commented

Excel files in Sharepoint read only

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!

office-sharepoint-server-administration
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

JoyZ avatar image
0 Votes"
JoyZ answered JoyZ commented

Hi @Anhalter42-1031,

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://docs.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.



image.png (3.4 KiB)
image.png (64.6 KiB)
· 6
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hi Julie,

I have already checked all options but could not make it work. Antivirus is deactivated (to be sure on client an server also), the setting in SP are correct, Office is activated (Word files work fine) and the files themselves have no write protection turned on. Any other ideas?

Thanks so far!

0 Votes 0 ·
JoyZ avatar image JoyZ Anhalter42-1031 ·

Hi @Anhalter42-1031,

Do all users occur the same issue in your organization when they open excel files?

What version of Excel are you using?

0 Votes 0 ·

yes, this affects all users and we are using Excel 2016 in version 16.0.5134.1000

0 Votes 0 ·
Show more comments