"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-14T03:55:10+00:00

    I an having the same issue on multiple device with Office 2016. Even though the file on SharePoint created by original person the file can't edit.

    Was this answer helpful?

    1 person found this answer helpful.
    0 comments
  2. Anonymous
    2023-03-14T20:39:26+00:00

    I'm having this issue as well with multiple users across 2016, 2019, and 2021. 365 appears to still work. We need a fix ASAP. Nothing on the Service Health Dashboard either.

    Was this answer helpful?

    0 comments
  3. Makapu 92,380 Reputation points Volunteer Moderator
    2023-03-14T21:20:14+00:00

    This response has been automatically translated. As a result, there may be grammatical errors or strange wording.

    Hi,

    This issue occurs in version 2302 (Build 16130.20218), so revert to Version 2301 (Build 16026.20200) （16.0.16026.20200）and disable Office updates.

    <Update history for Microsoft 365 Apps>

    ＊This article apply to Click-to-Run versions of Office.

    1. Start an Office application (such as Excel), and then select File > Account. select Update  Options  > Disable Updates. 

    Image

    1. Type cmd on the start menu, right click on the Command Prompt, choose Run as Administrator

    Image

    1. Copy/paste these two commands one at a time and press enter

    cd %programfiles%\Common Files\Microsoft Shared\ClickToRun

    officec2rclient.exe /update user updatetoversion=16.0.16026.20200

    FYI:

    How to revert to an earlier version of Office

    Microsoft 365 - revert to prevous build version

    If you use MSI versions of Office, delete windows update program.

    Was this answer helpful?

    4 people found this answer helpful.
    0 comments