"Unknown error trying to lock file." when opening file in Excel from SharePoint

Anonymous
2023-03-06T19:20:06+00:00

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.

0 comments
Answer accepted by question author
Anonymous
2023-03-30T03:11:11+00:00

After run update as picture the issue is resolved,

Was this answer helpful?

2 people found this answer helpful.
0 comments
Answer accepted by question author
Anonymous
2023-03-29T02:50:55+00:00

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

Was this answer helpful?

0 comments

46 additional answers

Sort by: Oldest
Most helpful Newest Oldest
  1. Anonymous
    2023-03-08T20:08:35+00:00

    I am seeing this issue too. I have clients on Office 2016 and Office 2019. Opening Excel documents from SharePoint online gives that error. Opening with Excel in the browser seems to work okay.

    Was this answer helpful?

    0 comments
  2. Anonymous
    2023-03-09T05:53:44+00:00

    Hi all,

    Recently there was a new incident posted to the Service Health Dashboard (SHD) as an incident SP525140 starting at 2023-03-09 1:50 AM (UTC). The user experience of this incident is Users may be unable to Edit Microsoft Office files in SharePoint Online and OneDrive for Business.

    More info: When users try to open Microsoft Excel files, they may receive the error: "Unknown error trying to lock file", and when users try to open Microsoft Word or PowerPoint files, they may simply fail to open, without displaying an error.

    Current status: We've determined that a recent update intended to enhance the Office file user experience contained a code regression that resulted in impact. We've developed a code fix and have begun the process to deploy the fix to the affected environment. We anticipate this fix to be fully saturated by our next scheduled communications update.

    Scope of impact: This event may impact any user trying to edit Office files in SharePoint Online and OneDrive for Business.

    Root cause: A recent update intended to enhance the Office file user experience contained a code regression that resulted in impact.

    You may subscribe to this thread or refer to the SHD for updated information. We will also post back here once the issue is resolved.

    Thanks for your cooperation and understanding.

    Sincerely,

    Sean | Microsoft Community Moderator

    [Edited]

    Was this answer helpful?

    10+ people found this answer helpful.
    0 comments
  3. Anonymous
    2023-03-09T11:48:06+00:00

    Thanks Sean. Can you post here when the update has been rolled out?

    Was this answer helpful?

    0 comments