A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
After run update as picture the issue is resolved,
This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
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.
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data
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.
Dear Kucster,
Thanks for posting in Microsoft community. We are glad to help you.
Based on your description, since only one device had the issue with Excel2016, and other devices could open different files normally on their side. We think this issue may related to the Excel2016 application.
We'd love to help, considering we mainly focus on general and build-in queries in Microsoft365 applications, we may have limited resource about Office2016.
At the same time, considering we have a dedicated channel Office Management - Microsoft Q&A, for you to be assisted properly, we sincerely recommend you go to that community and post a new thread, members and engineers over there will focus on the specific situation on your side and share specific suggestions. We are sure that our experts from that team can address your query effectively and accurately.
Thanks for your understanding and cooperation! Hope you keep safe and healthy always.
Sincerely,
Sean | Microsoft Community Moderator