Troubleshoot Locked Excel Workbooks in SharePoint
Question details
Determine why an Excel workbook appears locked or unavailable for editing in SharePoint or a synchronized folder.

- 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.
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.
Identify Where the Excel Workbook Appears Locked
Compare SharePoint and the synchronized folder to identify which permissions or library settings need investigation.
Open the document library on the SharePoint website and locate the workbook. Note any lock icon, status, or message shown there.
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.
Open the synchronized library in File Explorer and locate the same workbook. Note whether the lock icon or editing restriction also appears there.
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.
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.

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.

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.




