OneDrive Excel Sharing

%3CLINGO-SUB%20id%3D%22lingo-sub-7194%22%20slang%3D%22en-US%22%3EOneDrive%20Excel%20Sharing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7194%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%20We%20had%20a%20recent%20issue%20where%20one%20of%20our%20users%20told%20me%20they%20were%20getting%20a%20message%20when%20opening%20a%20Shared%20Excel%20Document%20in%20Excel%20Online.%20It%20was%20stating%20that%20the%20document%20was%20Locked%20for%20editing%20by%20another%20user.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIt%20turns%20out%20that%20another%20user%20had%20opened%20the%20document%20in%20Excel%20(Desktop)%20and%20this%20was%20causing%20the%20issue.%20Fortunately%20we%20were%20able%20to%20find%20out%20who%20the%20user%20was%20and%20ask%20them%20to%20close%20it.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20best%20practice%20on%20how%20we%20as%20an%20admin%20can%20see%20who%20has%20the%20file%20locked%20for%20editing%20and%20is%20there%20any%20mechanism%20that%20we%20can%20administratively%20close%20the%20file%20to%20allow%20others%20to%20edit%20the%20document%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAny%20help%2Fguidance%20appreciated.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7321%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Excel%20Sharing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7321%22%20slang%3D%22en-US%22%3EThanks.%20I'll%20check%20this%20out.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-7239%22%20slang%3D%22en-US%22%3ERe%3A%20OneDrive%20Excel%20Sharing%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-7239%22%20slang%3D%22en-US%22%3E%3CP%3EHey%20Scott%2C%20check%20out%20this%20page%20to%20help%20you%20%3CSPAN%3Econtrol%20document%20collaboration.%3C%2FSPAN%3E%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSet-up-a-library-to-require-check-out-of-files-0c73792b-f727-4e19-a1f9-3173899e695b%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%22%20target%3D%22_blank%22%20rel%3D%22noopener%20noreferrer%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fsupport.office.com%2Fen-us%2Farticle%2FSet-up-a-library-to-require-check-out-of-files-0c73792b-f727-4e19-a1f9-3173899e695b%3Fui%3Den-US%26amp%3Brs%3Den-US%26amp%3Bad%3DUS%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
Contributor

Hi, We had a recent issue where one of our users told me they were getting a message when opening a Shared Excel Document in Excel Online. It was stating that the document was Locked for editing by another user. 

 

It turns out that another user had opened the document in Excel (Desktop) and this was causing the issue. Fortunately we were able to find out who the user was and ask them to close it.

 

Is there a best practice on how we as an admin can see who has the file locked for editing and is there any mechanism that we can administratively close the file to allow others to edit the document?

 

Any help/guidance appreciated.

2 Replies
Highlighted

Hey Scott, check out this page to help you control document collaboration. https://support.office.com/en-us/article/Set-up-a-library-to-require-check-out-of-files-0c73792b-f72...

Highlighted
Thanks. I'll check this out.