Permission & Access Issues

Troubleshoot Locked Excel Workbooks in SharePoint

Nimra MalikNimra Malik Nov 14, 2026 868 views

Question details

Determine why an Excel workbook appears locked or unavailable for editing in SharePoint or a synchronized folder.

Troubleshoot Locked Excel Workbooks in SharePoint
Product
SharePoint and Microsoft Excel
Device & OS
not provided
Scenario
A user needs to edit a SharePoint workbook that may also be synchronized to File Explorer and linked to other workbooks.
Observed behavior
The workbook appears locked even though neither the user nor another authorized user has it open.
Before you start

Note the workbook name and library location, then check whether the lock appears on the SharePoint website, in File Explorer, or both. Keep any linked workbooks in mind before moving, renaming, or replacing the file.

Solution 1Recommended

Identify Where the Excel Workbook Appears Locked

Compare SharePoint and the synchronized folder to identify which permissions or library settings need investigation.

1
Check the SharePoint library

Open the document library on the SharePoint website and locate the workbook. Note any lock icon, status, or message shown there.

2
Try opening the workbook online

Select the workbook in SharePoint and try opening it in Excel for the web. Record the exact lock or editing error and capture a screenshot if one appears.

3
Compare the synchronized folder

Open the synchronized library in File Explorer and locate the same workbook. Note whether the lock icon or editing restriction also appears there.

4
Review access and library settings

In SharePoint, select the workbook and open Details or Manage access to review your access if available. Ask the library owner to check permissions, checkout requirements, and required columns or metadata, especially if the restriction appears only in the synchronized folder.

5
Share the findings

Send the library owner or SharePoint administrator the workbook location, where the lock appears, and the exact error or screenshot. Ask them to investigate the library configuration and synchronization settings.

Identify Where the Excel Workbook Appears Locked
Preserve workbook links: Avoid recreating, moving, or renaming the workbook as a first fix; other workbooks may depend on its existing location.
Free Microsoft Office alternative

Work With Excel-Compatible Files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for opening and editing compatible spreadsheets. It can help you migrate existing Office files, but it does not change SharePoint permissions or remove SharePoint locks.

Open and edit Excel-compatible spreadsheets in WPS Spreadsheets.Compatible with Microsoft Excel formats, including XLSX and XLS.Use a familiar interface to work with existing Office files.Keep a lightweight office suite available for everyday document work.
microsoft office alternative - wps office

Frequently Asked Questions

How can I tell whether the lock is in SharePoint or File Explorer?

Find the workbook in the SharePoint document library, then find the same file in the synchronized File Explorer folder. Compare the icons and any messages in both locations.

What should I check if the file is restricted only in the synchronized folder?

Ask the library owner to review synchronization restrictions and library settings, including required columns or metadata. Provide the file location and the icon or error you see in File Explorer.

What information should I give my SharePoint administrator?

Provide the workbook name and library location, whether the issue appears online or in File Explorer, and the exact editing error or a screenshot.

Should I recreate the locked workbook?

Investigate the lock first. Recreating or replacing the workbook can affect links from other workbooks, so consult the file owner before changing its name or location.

Can WPS Office remove a SharePoint lock?

No. A SharePoint lock or access restriction must be investigated in SharePoint and its synchronization settings. WPS Office can open supported Excel files when you have access to them.