Microsoft 365 and Office | Excel | For business | Windows
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
After run update as picture the issue is resolved,
"Unknown error trying to lock file." when opening file in Excel from SharePoint
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Anonymous
One of my users with Win 10 pro (upto date) is having trouble opening files (xlsx and xlsm) from SharePoint in Excel, they are getting the error "Unknown error trying to lock file." They are running Excel 2016, fully up to date. They were not having an issue Friday.
Tried the same files on SharePoint on other computers and did not get the same error. I tried via another user account on the computer that is having trouble and got the same error. I tried an Office repair, quick and full, which did not help. Teams and Outlook are on this computer and are having no trouble. I was also able to open word files on SharePoint with no issue.
I'm a little stymied any help would be greatly appreciated.
Microsoft 365 and Office | Excel | For business | Windows
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Anonymous
Answer accepted by question author
Anonymous
Hi All,
Updated, SP525140 was resolved, please check if you still have the issue on your side.
Thanks for your understanding and cooperation! Have a good day.
Sincerely,
Sean | Microsoft Community Moderator
46 additional answers
Sort by: Oldest
-
Anonymous
2023-03-28T04:48:55+00:00 I encountered an error while attempting to open an Excel file from a shared drive within the MS Teams app. Do you know if there are any updates from Microsoft regarding this issue?
-
Anonymous
2023-03-28T16:07:20+00:00 This bug only affects Excel but not Word or Powerpoint.
And it seems to tie to Office365 supporting co-authoring, whereas earlier versions like Office2019 did not.
I tried the various solutions in this thread but with no success.
A couple of Work-arounds until a proper fix is provided by Microsoft:
- Somehow uninstalling Teams and reinstalling Teams temporarily resolves the issue.
- Opening the Teams files in Sharepoint allows Checking them out to download for modification then upload & replace. That is not possible in Teams for some reason
-
Anonymous
2023-03-28T21:13:40+00:00 I can confirm. I started a ticket with MS on this and the person answering me has no clue. He's now asking for logs and stuff, feels like a waste of time.