Home

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
Scott Preston
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.
Related Conversations
formuale help
Gavc1 in Excel on
1 Replies
searching a sheet with a true and false function
Aaron_excel in Excel on
4 Replies
Excel Help - Stacking IF Formulas
MaddieLB in Excel on
2 Replies
Convert string to number of days
arjsharm in Excel on
2 Replies