Sharepoint and OneDrive Sync Making Files Read Only

Question

Hello, 

I have been using Sync with Sharepoint for quite some time without issue on my files; however, since September 16th all the files that I have synced from Sharepoint to my computer are set to Read Only. I have checked the Library settings to see if they had been updated recently; however, that does not appear to be the issue. I use synced files to link data to other reports; however, I have to run an update macro on some of the synced files everyday, and at the moment I am being forced to unsync the file every time I need to update it, and then resync again so that it is linked to local reports. I never had any issues with these reports prior to September 16th. Can anyone tell me what might have changed since then? The files that I have synced are largely excel files. 

Thanks for your help.

Answer 1

Dear Ldaxford,

This situation could be due to some settings in your Sharepoint library, so, I will explain to you, how verify and deactivate those most important features that could create a conflict with Onedrive client:

1.- Versioning settings: So, in any internet browser open your SPO site > Open the Document library > in upper-right of screen click on "Gear" button > click on "Library Settings" there you will see several configurations, so, click in "Versioning settings", inside there are two important configurations and they must be configured like this:

-Content Approval = "No"

-Require Check Out = "No"

So, save your changes.

2.- Back to Library settings > in "Columns" section, you should verify if you have a "Required" column on the list, if is it, that column will show you your synced files in "Read only" mode, so you have to edit the column and untick Required option and save.

3.- Limited-access user permission lockdown mode: Browse to the Site Settings that you want to configure, In the settings choose > Site collection features under the > Site Collection Administration heading. ​

Find "Limited-access user permission lockdown mode" and if its enabled, disable it and verify the behavior.

See all limitations in below Microsoft support:

https://support.microsoft.com/en-us/office/inva...

Regards,

Renzo.

Answer 2

Hello Renzo, 

Many thanks. I had previously checked the Require Check Out and Columns section, but was unaware of Content Approval option. I am unsure why that may have only recently become an issue; however, updating that solved the issue. Thanks for the detailed description of how to find the settings and update.

Answer 3

You are welcome, have a nice day.