SharePoint Document Issues

Fix Excel 2016 Unknown Error Trying to Lock File in SharePoint

Camila MilosovichCamila Milosovich Oct 19, 2026 868 views

Question details

Users are unable to open Excel files from SharePoint due to a file locking error in the desktop application.

How to Fix Excel 2016 'Unknown Error Trying to Lock File' with SharePoint
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.
Before you start

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.

Solution 1Recommended

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.

1
Sign Out of Office

Open the Excel 2016 desktop app, click on 'Account' (or 'File' > 'Account'), and select 'Sign Out'.

2
Reopen the File

Navigate back to your SharePoint library and attempt to open the XLSX or XLSM file again.

3
Sign Back In

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.

Sign Out and Re-Sign Into Microsoft Office
Restart Required: In some cases, Windows caching prevents the authentication refresh from working immediately. A system restart ensures all background Microsoft Office services are fully reset.
Free Microsoft Office alternative

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. 1. Install WPS Office: Download and install the free WPS Office suite from the official website onto your Windows 10 computer.
  2. 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. 3. Edit Seamlessly: Open the downloaded file using WPS Spreadsheet to continue editing your data without encountering any locking errors.
Fully compatible with Microsoft Excel formats (XLSX, XLS, XLSM)Lightweight installation with incredibly fast loading timesFree to use with a familiar, easy-to-navigate interfaceBuilt-in cloud syncing capabilities for seamless document collaboration
microsoft office alternative - wps office

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.