Jan 25 2019 11:01 AM
Hi folks - We're experiencing an issue where an Excel spreadsheet checked out to a team member still remains in read only view and they are unable to edit it. If they try to edit it, they get a message telling them: Cant Edit Workbook - [team member name] has the workbook locked. Ask them to close the file or check it in. However... the team member name that shows in the error is the same team member who is trying to edit. So, the error is essentially telling them they can't edit something because they're the one who has it checked out. This is sporadic, thru testing we've determined this error occurs 90% of the time with Chrome and IE, I only received the error once when using MS Edge. This is happening for me (SP admin) as well as other team members. I have a list below of the various troubleshooting I've tried.
Jan 27 2019 11:48 PM
Jan 28 2019 07:46 AM
It's Excel 365
Feb 01 2019 10:56 AM
For anyone keeping tabs on this issue, I now have a ticket open with Microsoft and they're doing research to identify a solution. I'll update this post when we come to a conclusion on this.
Apr 07 2019 06:19 PM
@Kateraid did this issue get fixed in your environment.
May 08 2019 06:56 AM
@Mahendra Ranaweera no, not yet. I've been working with Microsoft. They've been trying to pull logs of the issue occurring, but the log tool they're using keeps shutting down before we can complete the exercise on Chrome. Their log tool works on the other browsers, but the other browsers are sporadic with the issue and we didn't happen to experience the issue on the other browsers while they were running their log tool, therefore they've advised since we can't recreate the issue in the other browsers while their log tool is running they've concluded this is not an issue on non-Chrome browsers. I have screen captures of the issue occurring, and the MS team members have witnessed it happen while on screen share sessions with me, but because they can't capture a successful log they tell me their tech support team can't do any research on the issue. At this time they've told me to avoid Chrome, which is problematic for my company for a variety of other reasons. To say I'm disappointed is putting it lightly. After a few of my company's big projects wrap up & I have more availability from other team members, I'm planning to leverage another team member to see if they have better luck running the Microsoft log tool while recreating the issue in chrome so we can capture a successful log. I spent several hours over multiple ph calls with the MS tech support group and every time we tried this on my computer their log tool crashed. I'll update this post again when we get to that point.
Mar 08 2022 02:01 AM
@Kateraid have you got any further updates on this issue yet?
Mar 08 2022 08:40 AM
@JSHEP73 I spent hours on the phone with Microsoft and in the end they said two things would fix the issue: (1) use their MS Edge browser, and (2) wait up to an hour after the item has been checked-in before someone else tries to check it out. When these two things were followed in testing, the issue could no longer be recreated. On my side, we don't use the Edge browser (we use Chrome) and it's not always tenable to wait an hour for someone to check out the spreadsheet again so this was painful for us for a while. Having said this, this issue hasn't come up again for us in months so I assumed some enhancement in one of the windows patches helped.