Fix Excel 2016 Unknown Error Trying to Lock File in SharePoint
Question details
Users are unable to open Excel files from SharePoint due to a file locking error in the desktop application.

- Product
- Microsoft Excel 2016
- Device & OS
- Windows 10
- Scenario
- Opening XLSX or XLSM files from a SharePoint library using the Excel 2016 desktop application.
- Observed behavior
- Excel displays an 'Unknown error trying to lock file' message, preventing the file from opening, even though other Microsoft 365 apps work normally and the file can be edited within SharePoint online.
Ensure your computer is connected to a stable internet network and verify that you have the appropriate read and write permissions for the SharePoint document library.
Sign Out and Re-Sign Into Microsoft Office
Refreshing your Microsoft Office authentication credentials can resolve temporary syncing and locking errors with SharePoint.
Authentication glitches between the Excel desktop client and SharePoint Online are a common cause of this file lock error. Forcing a new login session often restores normal functionality.
Open the Excel 2016 desktop app, click on 'Account' (or 'File' > 'Account'), and select 'Sign Out'.
Navigate back to your SharePoint library and attempt to open the XLSX or XLSM file again.
When prompted by Excel, enter your Microsoft 365 credentials to sign back in. If the error persists, restart your Windows 10 computer and try again.

Add the OneDrive Sync Folder to Trusted Locations
If you sync SharePoint using OneDrive, Excel's security settings may block the file unless the synchronized folder is explicitly trusted.
Download the File Locally and Check Compatibility
Determine if the issue is an isolated Excel 2016 compatibility bug by testing the file locally on your hard drive.
Try WPS Office for Seamless Spreadsheet Management
If Excel 2016 continues to struggle with SharePoint compatibility and locking errors, consider switching to WPS Office. It is a highly compatible, lightweight, and free alternative that opens, edits, and saves XLSX files effortlessly without frustrating lock errors.
- 1. Install WPS Office: Download and install the free WPS Office suite from the official website onto your Windows 10 computer.
- 2. Download the Problematic File: Navigate to your SharePoint document library via your web browser and download the locked XLSX or XLSM file to your local drive.
- 3. Edit Seamlessly: Open the downloaded file using WPS Spreadsheet to continue editing your data without encountering any locking errors.

Frequently Asked Questions
Why does Excel 2016 show an 'Unknown error trying to lock file' message?
This error typically happens due to authentication token conflicts between the Excel desktop client and SharePoint Online, or when the local OneDrive synced folder is not recognized as a Trusted Location in Excel's security settings.
Can I still edit my spreadsheet without fixing this desktop error?
Yes. While the desktop app is experiencing issues, you can usually edit the same file directly in the SharePoint online web interface, or simply download the file to your computer and open it locally.
Will this locking error affect my other Microsoft Office applications?
Generally, no. This specific locking error is mostly isolated to Excel 2016. Other applications like Microsoft Word, Outlook, and Teams usually continue to function and sync with SharePoint normally.




