Excel Document on sharepoint only opening in desktop read only

%3CLINGO-SUB%20id%3D%22lingo-sub-1408756%22%20slang%3D%22en-US%22%3EExcel%20Document%20on%20sharepoint%20only%20opening%20in%20desktop%20read%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408756%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20there.%20My%20organization%20uses%20SharePoint%20so%20that%20the%20entire%20team%20can%20edit%20a%20single%20document%2C%20often%20simultaneously%20through%20the%20Online%20app%20(usually%20through%20Internet%20Explorer).%20However%2C%20I%20have%20experienced%20a%20unique%20problem%20nobody%20else%20on%20my%20team%20is%20having.%20When%20I%20try%20to%20access%20this%20particular%20document%2C%20I%20get%20a%20notification%20it%20cannot%20be%20opened%20online%20and%20goes%20to%20the%20desktop%20app%3A%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22openindesktopapp.PNG%22%20style%3D%22width%3A%20467px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F193572i37697307CBA69EE8%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22openindesktopapp.PNG%22%20alt%3D%22openindesktopapp.PNG%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EWhen%20I%20proceed%2C%20I%20am%20informed%20that%20the%20document%20is%20locked%20for%20editing...%20by%20me.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAfter%20asking%20around%2C%20it%20appears%20I%20am%20the%20only%20one%20on%20my%20team%20experiencing%20this.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1408756%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1408836%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Document%20on%20sharepoint%20only%20opening%20in%20desktop%20read%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1408836%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675753%22%20target%3D%22_blank%22%3E%40scottox01%3C%2FA%3E%26nbsp%3B-%20super%20frustrating.%20Is%20everyone%20using%20Excel%20for%20O365%3F%20%3CSPAN%3EI've%20seen%20this%20a%20few%20times%20when%20someone's%20OneDrive%20sync%20client%20has%20stopped%20working%20properly.%20Check%20out%20this%20article%3A%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-file-is-locked-for-editing-by-another-user-6fa93887-2c2c-45f0-abcc-31b04aed68b3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2Fexcel-file-is-locked-for-editing-by-another-user-6fa93887-2c2c-45f0-abcc-31b04aed68b3%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3E%26nbsp%3B%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EHope%20that%20helps!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1410507%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Document%20on%20sharepoint%20only%20opening%20in%20desktop%20read%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1410507%22%20slang%3D%22en-US%22%3EHi%20Scot%20%26amp%3B%20Kelly%3CBR%20%2F%3EBy%20any%20chance%20you%20know%20if%20sharepoint%20keep%20a%20r%C3%A9cord%20if%20any%20team%20member%20download%20any%20document%20to%20his%2Fher%20own%20laptop%2Fdesktop%3F%3CBR%20%2F%3Ethanks%3CBR%20%2F%3EMegan%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1411163%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Document%20on%20sharepoint%20only%20opening%20in%20desktop%20read%20only%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1411163%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675199%22%20target%3D%22_blank%22%3E%40cubachiki%3C%2FA%3E%26nbsp%3Bgo%20to%20Site%20settings%20and%20in%20the%20Site%20Collection%20Administration%20section%20click%20on%20Audit%20log%20reports.%20I've%20sometimes%20found%20it%20doesn't%20work%20well%20or%20gives%20an%20error%2C%20but%20have%20just%20saved%20a%20report%20on%20documents%20viewed%2Fdownloaded%20this%20week%20from%20the%20Custom%20Report%20option%20at%20the%20bottom%20of%20the%20list.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERob%3CBR%20%2F%3ELos%20Gallardos%3CBR%20%2F%3E%3CFONT%20size%3D%222%22%20color%3D%22%23333399%22%3EMicrosoft%20Power%20Automate%20Community%20Super%20User%3C%2FFONT%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Occasional Visitor

Hi there. My organization uses SharePoint so that the entire team can edit a single document, often simultaneously through the Online app (usually through Internet Explorer). However, I have experienced a unique problem nobody else on my team is having. When I try to access this particular document, I get a notification it cannot be opened online and goes to the desktop app:

 

openindesktopapp.PNG

 

When I proceed, I am informed that the document is locked for editing... by me.

 

After asking around, it appears I am the only one on my team experiencing this.

3 Replies
Highlighted

Hi @scottox01 - super frustrating. Is everyone using Excel for O365? I've seen this a few times when someone's OneDrive sync client has stopped working properly. Check out this article: https://support.office.com/en-us/article/excel-file-is-locked-for-editing-by-another-user-6fa93887-2...

 

Hope that helps!

Highlighted
Hi Scot & Kelly
By any chance you know if sharepoint keep a récord if any team member download any document to his/her own laptop/desktop?
thanks
Megan
Highlighted

@cubachiki go to Site settings and in the Site Collection Administration section click on Audit log reports. I've sometimes found it doesn't work well or gives an error, but have just saved a report on documents viewed/downloaded this week from the Custom Report option at the bottom of the list.

 

Rob
Los Gallardos
Microsoft Power Automate Community Super User