How to Unlock a Locked SharePoint Excel File Without Removing Access
Question details
The user needs to unlock an Excel file in SharePoint that is locked for editing, often due to pending checkouts or active sessions, while maintaining existing read-only permissions for other users.
- Product
- Microsoft SharePoint / Excel
- Device & OS
- not provided
- Scenario
- Collaborating on shared Excel spreadsheets in a SharePoint document library where a file becomes locked and unavailable for editing.
- Observed behavior
- The Excel file remains locked for editing, prompting a lock message, despite assigning read-only permissions to the user who allegedly holds the lock.
Ensure you have Site Owner or Library Administrator permissions in SharePoint, as standard user rights cannot override another user's checkout status or modify library settings.
Discard the Checkout as a Site Administrator
If the file is locked because it was checked out by another user, an administrator can forcefully override this lock by discarding the checkout.
A common reason for an Excel file to remain locked in SharePoint is that another user checked it out and forgot to check it back in. Read-only permissions alone do not clear an existing checkout lock.
Open your SharePoint site and go to the document library where the locked Excel file is located.
Find the Excel file. You may see a small arrow icon over the Excel file type icon, indicating it is checked out.
Click the ellipsis (three dots) next to the file name, select 'More', and then click 'Discard check out'. Confirm the prompt if asked.
Disable Required Checkout in Library Settings
Prevent frequent file locking issues by turning off the mandatory checkout requirement in your SharePoint library.
Verify and Reassign User Permissions
Ensure the user holding the lock does not have conflicting permission levels preventing the system from releasing the file.
Experience Seamless Collaboration with WPS Office
Avoid complex SharePoint checkout locks by switching to WPS Office. Enjoy real-time cloud co-authoring, lightweight performance, and complete compatibility with all Microsoft Excel formats without the hassle.
- 1. Download WPS Office: Visit the official WPS Office website to download the free application for your device.
- 2. Open your files: Open your existing Excel spreadsheets directly in WPS Spreadsheet with perfect formatting retention.
- 3. Collaborate easily: Use WPS Cloud to share links and co-author documents with your team in real-time.
Frequently Asked Questions
Why does my SharePoint Excel file say it is locked for editing?
This usually happens when another user has the file open, forgot to check it back into the library, or their browser session timed out improperly, leaving an active lock on the server.
Can I unlock an Excel file if I am not the SharePoint site owner?
Generally, no. Only the user who initially checked out the file or an administrator with Full Control or Design permissions can manually override and discard a checkout lock.
How long does a SharePoint lock last if someone just closed their browser?
A temporary lock caused by an unexpected browser closure or crash typically clears by itself after 10 to 15 minutes of inactivity on the server.
