Fix Excel Password-Protected Workbooks Locked for Editing in SharePoint
Question details
Resolve an editing lock on a password-protected Excel workbook stored in SharePoint or synchronized through OneDrive.
- Product
- Microsoft Excel, SharePoint, and OneDrive
- Device & OS
- not provided
- Scenario
- A user saves changes to a password-protected workbook stored in SharePoint or a synchronized OneDrive folder and then tries to continue editing.
- Observed behavior
- The workbook appears locked for editing even though no other user is known to be using it.
Confirm that you know the workbook password and have editing permission in SharePoint. The credential and Task Manager steps below apply to Windows; save any open Office work before closing applications.
Clear cached Office credentials and sign in again
Use this Windows procedure to rule out stale Office sign-in credentials as the cause of the editing lock.
In Excel, open File > Account and sign out of your Office accounts. Under Connected Services, remove connected services if the option is available.
Close Excel and any other open Office applications.
Open Control Panel > User Accounts > Credential Manager > Windows Credentials. Under Generic Credentials, remove entries associated with Microsoft Office.
Restart Windows, open Excel, and sign in to your Office account. Reopen the workbook from SharePoint or the synchronized OneDrive folder and test editing.
Test a workbook copy and check for a remaining Excel process
Use a separate copy to check whether the lock affects the original workbook or also occurs during a fresh editing session.
Open and Edit Excel Workbooks with WPS Office
WPS Office is a free, lightweight alternative with a familiar interface for working with Microsoft Office files. It can help you transition between office suites, although it does not fix Excel or SharePoint editing locks.
Frequently Asked Questions
Why does my workbook say it is locked when nobody else is editing it?
A remaining Excel process, cached credentials, or a SharePoint or OneDrive session may be involved. Close Excel, check Task Manager for a remaining Excel process, and test the credential reset if the lock persists.
Where do I find cached Office credentials in Windows?
Open Control Panel > User Accounts > Credential Manager > Windows Credentials. Look under Generic Credentials for entries associated with Microsoft Office.
Will saving a copy unlock the original SharePoint workbook?
No. File > Save a Copy or File > Save As creates a separate workbook for testing; it does not remove the lock from the original.
What should I check if I still cannot edit the workbook?
Confirm that your SharePoint account has editing permission, then test the workbook from another Windows user account. If the issue persists across multiple protected workbooks, contact your SharePoint or Microsoft 365 administrator with the test results.
Can WPS Office remove a SharePoint lock created by Excel?
No. WPS Office is an alternative for working with compatible spreadsheet files, but a SharePoint or Excel editing lock must be addressed in the original Microsoft environment.
