SOLVED

Office documents in a SharePoint Library opens in Read Only mode, when opened with Office Desktop

%3CLINGO-SUB%20id%3D%22lingo-sub-1528812%22%20slang%3D%22en-US%22%3EOffice%20documents%20in%20a%20SharePoint%20Library%20opens%20in%20Read%20Only%20mode%2C%20when%20opened%20with%20Office%20Desktop%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528812%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWe%20are%20experiencing%20a%20rather%20complex%20bug%2Fissue%20in%20SharePoint%20which%20we%20cannot%20seem%20to%20figure%20out.%20We%20cannot%20find%20any%20forum%20posts%20covering%20this%20exact%20issue%20either.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3ESymptom%3A%26nbsp%3B%3C%2FSTRONG%3EWhen%20opening%20any%20Word%2C%20Excel%20or%20PowerPoint%20files%20from%20a%20particular%20SharePoint%20Site%20Collection%20Library%2C%20using%20Office%20Desktop%2C%20the%20files%20are%20Read-Only.%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E%3CSTRONG%3ERemarks%3A%3C%2FSTRONG%3E%3C%2FP%3E%3CUL%3E%3CLI%3EWhen%20opening%20in%20Online%20Office%20programs%2C%20the%20files%20can%20be%20edited%20with%20no%20issues.%20This%20only%20occur%20when%20opening%20using%20Desktop%20apps.%26nbsp%3B%3C%2FLI%3E%3CLI%3EOur%20current%20Office%20version%20is%202005%3C%2FLI%3E%3CLI%3EThis%20particular%20library%20has%20custom%20metadata%20columns.%20We%20have%20tested%20to%20make%20these%20columns%20optional%2C%20and%20also%20reviewed%20whether%20they%20can%20cause%20potential%20compatibility%20issues%20in%20Office%20Desktop%20programs.%26nbsp%3B%3C%2FLI%3E%3CLI%3EThe%20two%20users%20who%20have%20been%20used%20for%20testing%20this%20are%20both%20Site%20Collection%20Admins%20and%20also%20Site%20Owners.%26nbsp%3B%3C%2FLI%3E%3CLI%3EThere%20are%20no%20Label%20settings%3C%2FLI%3E%3CLI%3EDocuments%20are%20not%20stored%20as%20records%3C%2FLI%3E%3CLI%3EWe%20have%20never%20experienced%20this%20issue%20before.%20To%20that%20note%20it%20has%20been%20a%20while%20since%20the%20last%20time%20we%20tested%20using%20metadata%20columns%3C%2FLI%3E%3C%2FUL%3E%3CP%3E%3CSTRONG%3EScreenshots%20of%20configuration%20are%20attached.%3C%2FSTRONG%3E%3C%2FP%3E%3CDIV%20class%3D%22mceNonEditable%20lia-copypaste-placeholder%22%3E%26nbsp%3B%3C%2FDIV%3E%3CP%3EWe%20would%20really%20appreciate%20any%20help%20with%20this.%20If%20we%20can't%20resolve%20it%2C%20we'll%20have%20to%20delete%20this%20Library%2C%20wiping%20a%20good%20amount%20of%20hours%20worth%20of%20work%20and%20potentially%20running%20into%20the%20same%20issue%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1528812%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1528936%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20documents%20in%20a%20SharePoint%20Library%20opens%20in%20Read%20Only%20mode%2C%20when%20opened%20with%20Office%20Deskto%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1528936%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F94068%22%20target%3D%22_blank%22%3E%40Anders%20Linner%3C%2FA%3E%3C%2FP%3E%3CP%3EI%20found%20this%20artice%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Ftroubleshoot%2Flists-and-libraries%2Ffiles-open-as-read-only-and-cannot-check-in-or-out%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fdocs.microsoft.com%2Fen-us%2Fsharepoint%2Ftroubleshoot%2Flists-and-libraries%2Ffiles-open-as-read-only-and-cannot-check-in-or-out%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMaybe%20that%20is%20a%20hint.%20If%20not%20I'm%20afraid%20you%20need%20to%20open%20a%20support%20ticket.%3C%2FP%3E%3CP%3EI%20hope%20it%20helps%3C%2FP%3E%3CP%3ECheers%3CBR%20%2F%3ERolf%3CBR%20%2F%3E%3CBR%20%2F%3E%23MCT%20%23LearnWithRolf%20%23TheCloud42%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1532509%22%20slang%3D%22en-US%22%3ERe%3A%20Office%20documents%20in%20a%20SharePoint%20Library%20opens%20in%20Read%20Only%20mode%2C%20when%20opened%20with%20Office%20Deskto%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1532509%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F659330%22%20target%3D%22_blank%22%3E%40Rolf-42%3C%2FA%3E!%20Yours%20and%20our%20cloud%20support's%20responses%20solved%20it%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSTRONG%3E%3CEM%3EDraft%20Item%20Security%26nbsp%3B%3C%2FEM%3E%3C%2FSTRONG%3E%3C%2FP%3E%3COL%3E%3CLI%3E%3CEM%3EBrowse%20to%20the%20document%20library%20that%20you%20want%20to%20configure.%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EIn%20the%20toolbar%2C%20on%20the%20%3CSTRONG%3ELibrary%3C%2FSTRONG%3E%20tab%2C%20in%20the%20Settings%20group%2C%20choose%20%3CSTRONG%3ELibrary%20Settings%3C%2FSTRONG%3E.%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EIn%20%3CSTRONG%3EGeneral%20Settings%3C%2FSTRONG%3E%2C%20choose%20%3CSTRONG%3EVersioning%20settings%3C%2FSTRONG%3E.%3C%2FEM%3E%3C%2FLI%3E%3CLI%3E%3CEM%3EIn%20%3CSTRONG%3EDraft%20Item%20Security%3C%2FSTRONG%3E%20select%20%3CSTRONG%3EAny%20user%20who%20can%20read%20items%26nbsp%3B%3C%2FSTRONG%3E(default).%3C%2FEM%3E%3C%2FLI%3E%3C%2FOL%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi, 

 

We are experiencing a rather complex bug/issue in SharePoint which we cannot seem to figure out. We cannot find any forum posts covering this exact issue either. 

 

Symptom: When opening any Word, Excel or PowerPoint files from a particular SharePoint Site Collection Library, using Office Desktop, the files are Read-Only. 

Remarks:

  • When opening in Online Office programs, the files can be edited with no issues. This only occur when opening using Desktop apps. 
  • Our current Office version is 2005
  • This particular library has custom metadata columns. We have tested to make these columns optional, and also reviewed whether they can cause potential compatibility issues in Office Desktop programs. 
  • The two users who have been used for testing this are both Site Collection Admins and also Site Owners. 
  • There are no Label settings
  • Documents are not stored as records
  • We have never experienced this issue before. To that note it has been a while since the last time we tested using metadata columns

Screenshots of configuration are attached.

 

We would really appreciate any help with this. If we can't resolve it, we'll have to delete this Library, wiping a good amount of hours worth of work and potentially running into the same issue in the future. 

2 Replies
Highlighted
Best Response confirmed by Anders Linner (New Contributor)
Solution

Hello @Anders Linner

I found this artice: https://docs.microsoft.com/en-us/sharepoint/troubleshoot/lists-and-libraries/files-open-as-read-only... 

Maybe that is a hint. If not I'm afraid you need to open a support ticket.

I hope it helps

Cheers
Rolf
#MCT #LearnWithRolf #TheCloud42 

Highlighted

Thanks @Rolf-42! Yours and our cloud support's responses solved it:

 

Draft Item Security 

  1. Browse to the document library that you want to configure.
  2. In the toolbar, on the Library tab, in the Settings group, choose Library Settings.
  3. In General Settings, choose Versioning settings.
  4. In Draft Item Security select Any user who can read items (default).