Excel file opens read-only in specific library only in local app

%3CLINGO-SUB%20id%3D%22lingo-sub-826091%22%20slang%3D%22en-US%22%3EExcel%20file%20opens%20read-only%20in%20specific%20library%20only%20in%20local%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826091%22%20slang%3D%22en-US%22%3E%3CP%3EWhen%20opening%20an%20Excel%20file%20in%20local%20app%20via%20SharePoint%2C%20the%20Excel%20file%20is%20always%20in%20read-only.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20explain%20the%20situation%3A%3C%2FP%3E%3CP%3EOnly%20one%20user%20has%20this%20issue%20at%20a%20firm%2C%20other%20users%20in%20the%20same%20authorization%20group%20don't%20experience%20this%20issue.%3C%2FP%3E%3CP%3EIssue%20is%20only%20on%20a%20specific%20document%20library%2C%20other%20libraries%20in%20the%20%22Team%22%20function%20like%20they%20should.%3C%2FP%3E%3CP%3EOnly%20happens%20when%20opening%20it%20in%20local%20app%2C%20opening%20it%20in%20the%20web%20has%20the%20expected%20result.%3C%2FP%3E%3CP%3EIssue%20also%20shows%20when%20the%20user%20creates%20an%20Excel%20file%20and%20uploads%20it%20to%20that%20library.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20far%20the%20authorization%20has%20been%20checked%2C%20no%20specific%20authorization%20has%20been%20set.%20The%20user%20is%20in%20the%20same%20group%20as%20people%20who%20don't%20experience%20it.%20This%20makes%20me%20think%20it%20has%20to%20do%20with%20the%20Excel%20settings%2C%20but%20the%20issue%20doesn't%20show%20on%20another%20library%20so%20I%20have%20no%20clue%20what%20it%20could%20be.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EDoes%20anyone%20have%20any%20suggestions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20more%20information%20is%20needed%2C%20please%20ask%20and%20I'll%20do%20my%20best%20to%20provide%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEDIT%3A%20Just%20confirmed%20that%20on%20another%20laptop%20it%20works%20fine%2C%20so%20it%20must%20be%20something%20in%20Excel.%20Still%20I%20don't%20understand%20why%20it%20only%20happens%20in%20this%20specific%20library.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826091%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826987%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20file%20opens%20read-only%20in%20specific%20library%20only%20in%20local%20app%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-826987%22%20slang%3D%22en-US%22%3EIs%20this%20user%20syncing%20this%20library%3F%20Might%20be%20related.%20But%20only%20other%20way%20I%20could%20see%20this%20happening%20is%20if%20this%20user%20has%20an%20older%20Excel%20not%20supporting%20coauthoring%20so%20it%20see's%20read%20only%2C%20but%20I'm%20going%20to%20assume%20that%20they%20can%20just%20click%20on%20edit%20button%20on%20the%20banner%20and%20continue%20fine%3F%20I%20do%20know%20auto%20save%20saves%20per%20file%20now%20so%20once%20you%20change%20it%2C%20going%20forward%20it%20could%20be%20off%2C%20which%20would%20open%20in%20read%20only%2C%20check%20to%20see%20if%20this%20is%20on%20as%20well%20when%20opening%20file.%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

When opening an Excel file in local app via SharePoint, the Excel file is always in read-only.

 

Let me explain the situation:

Only one user has this issue at a firm, other users in the same authorization group don't experience this issue.

Issue is only on a specific document library, other libraries in the "Team" function like they should.

Only happens when opening it in local app, opening it in the web has the expected result.

Issue also shows when the user creates an Excel file and uploads it to that library.

 

So far the authorization has been checked, no specific authorization has been set. The user is in the same group as people who don't experience it. This makes me think it has to do with the Excel settings, but the issue doesn't show on another library so I have no clue what it could be.

 

Does anyone have any suggestions?

 

If more information is needed, please ask and I'll do my best to provide it. 

 

EDIT: Just confirmed that on another laptop it works fine, so it must be something in Excel. Still I don't understand why it only happens in this specific library. 

1 Reply
Highlighted
Is this user syncing this library? Might be related. But only other way I could see this happening is if this user has an older Excel not supporting coauthoring so it see's read only, but I'm going to assume that they can just click on edit button on the banner and continue fine? I do know auto save saves per file now so once you change it, going forward it could be off, which would open in read only, check to see if this is on as well when opening file.