Fix Excel File in Use and Locked for Editing Errors
Question details
The user needs to regain editing access to an Excel file that appears to be locked by another user.

- Product
- Microsoft Excel for Microsoft 365
- Device & OS
- not provided
- Scenario
- An Excel workbook is stored in a shared location and must be edited after another user or former employee used it.
- Observed behavior
- Excel displays a File in Use or locked for editing message, even though the named user may no longer have the workbook open.
Identify where the workbook is stored and ask everyone who can access it to close the file. Check whether the message names a current user, a former employee, or your own account.
Remove an Orphaned Excel Lock File
Use this method when the workbook is in a local or shared folder and a temporary lock file remains after everyone has closed it.
Close the workbook in Excel on your device and confirm that all other users have closed it, including on other devices.
Open the workbook's folder in your file manager and show hidden files if necessary. Look for a temporary file beginning with ~$ and matching the workbook name.
Only after confirming that nobody is editing the workbook, delete the matching ~$ lock file. Do not delete the actual workbook.
Open the original workbook in Excel and check whether you can edit it.

Ask an Administrator to Check a File Server Session
Use this approach when a workbook on a file server remains locked after all users have closed it.
Check SharePoint or OneDrive Access and Collaboration
Use this method when the workbook is stored in SharePoint or OneDrive and the lock or editing restriction persists.
Work With Excel Files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for opening and editing spreadsheets. Its Excel format support makes it easy to move existing workbooks into WPS; it does not bypass server locks or access permissions.

Frequently Asked Questions
Why does Excel say a former employee has my file open?
The name may come from an orphaned ~$ lock file, a stale server session, or cached collaboration information. Confirm that no one is editing before removing a lock file or asking an administrator to clear a session.
Can I delete the file that starts with ~$?
If it matches the workbook and everyone has closed the workbook, you can delete the orphaned temporary file from the same local or shared folder. Do not delete the original workbook.
What if the workbook is on SharePoint?
Open the document library in a browser, check the file's status and Manage access, and confirm that all users have closed it. If the lock persists after waiting, ask a site administrator to investigate.
Can WPS Office remove an Excel server lock?
No. WPS Office can open compatible Excel files, but a server lock or permission restriction must be resolved at the storage location before you can edit the shared workbook.




