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

%3CLINGO-SUB%20id%3D%22lingo-sub-826071%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-826071%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%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-826071%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EApp%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EDocument%20Library%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-826656%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-826656%22%20slang%3D%22en-US%22%3Ecan%20you%20try%20by%20deleting%20upload%20center%20cache%20files%20from%20that%20user%20machine.%3CBR%20%2F%3E%3CBR%20%2F%3ETo%20delete%20Upload%20center%20cache%20file%20-%26gt%3B%20click%20start%20-%26gt%3B%20search%20for%20upload%20center%20-%26gt%3B%20and%20check%20any%20file%20is%20pending%20in%20queue%20-%26gt%3B%20then%20click%20settings%20-%26gt%3B%20and%20click%20delete%20cache%20file.%3C%2FLINGO-BODY%3E
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. 

1 Reply
can you try by deleting upload center cache files from that user machine.

To delete Upload center cache file -> click start -> search for upload center -> and check any file is pending in queue -> then click settings -> and click delete cache file.