Forum Discussion
File locking issue
Please find below the problem, cause and resolution provided by Microsoft..
Note : - we do not use check in - check out in our environment...
Hope this helps
Stewart
PROBLEM
================================
there are some users report of upload failed issue, sometimes, it can be completed by retry, some time, it will always failed.
Also many different symptoms when saving on both office and SP side which point to lock issue.
CAUSE & RESOLUTION
=================================
CAUSE: web client service add lock on the file
RESOLUTION: since no need for checkout/checkin, add below registry to disable the lock function of web client service but keep all other functions like explorer view support
HKLM\SYSTEM\CurrentControlSet\Services\WebClient\Parameters\SupportLocking=0
ADDITIONAL INFORMATION AND RECOMMENDATIONS
================================================
Registry to disable lock function when web client service is started:
- Start webclient service on user side
- Find registry: HKLM\SYSTEM\CurrentControlSet\Services\WebClient\Parameters on their machines.
- Find value: SupportLocking(if no, please add), set its value to 0, want to just disable lock feature.
We are having the same issue. If you edit in teams it is ok, if you edit online it is ok but if you edit in the (thick client) excel it locks the file and will not let you upload it. BUT the only way to work on the complicated formulas is by editing in the thick client.
The biggest issues is not the collaboration part as that work it is when you check out the file there is no way to get it back uploaded again.
This is what worked for me. After syncing the library and finding the lock symbol on all the files in the library displayed in my File Explorer, this is what I did:
- Remove all required column status from all fields. Be sure to include the default Title field. You might have to drill into the Document and/or Item Content Types to get to it. (I have found that it seems to be set as a required field by default in the standard Document content type)
- Enable version control inclusive of drafts, be sure it is set for 'anyone who can read'. Save. Then return and disable it.
- Enable Content Approval and save. Then return and disable it.
The key one, for whatever reason, was #3. When I did that, a message box popped up on my monitor saying something like 'you can now edit your files in OneDrive'. When I checked my File Explorer, the locks were gone. I verified today that other users who are syncing this library to their File Explorer are also now able to edit the files (the lock was gone for them, too).
Below is my original post.... LOL.... I was pretty excited to see that this worked. I hope it does for you, too.
Out of desperation, I enabled Content Approval and then disabled Content Approval and.....
Low and behold I got a pop up from ODB saying 'You can now edit your files'. I opened my File Explorer....yes...wait for it....and the LOCK WAS GONE! OMG, I spent hours on this to find that it was one check box for a feature I'd never enabled for the library. Why it was affecting its performance, I haven't a clue, but it worked. WHEW!