https://store-images.s-microsoft.com/image/apps.57613.a7840529-5ba7-45a4-8062-ce323ea90c70.bc8c03c6-0598-4508-9e08-00920946c1d1.3877298b-3de5-4158-a630-d56759f19ec0.png

Locked File Finder

by JoeZhou

Find locked Excel file

Do you find you can't edit a library or folder for some reason even after you already checked there is no checked out files in them?

This is most likely caused by some users are opening Excel file on their computer and you have co-authoring enabled on the library. There is no visiable sign in SharePoint for these locked Excel file.

You can see this behavior with the following test and use the App to find who is locking the files easily.

In an document library, make sure "required check out" is turned off to enable co-authoring. Open an Excel file in client application as user 1. start another session with a different browser as user 2. You will find user 2 can't rename/delete the library and folders which contains the excel file. And there is no easy way for user 2 to find user 1 is locking the Excel file.

Now open the App and you will see it can find the locked Excel file by inputting the library URL. ​​​

At a glance

https://store-images.s-microsoft.com/image/apps.22553.a7840529-5ba7-45a4-8062-ce323ea90c70.bc8c03c6-0598-4508-9e08-00920946c1d1.66fe0e80-e206-463e-891d-407c8c5891d7.png