Permission & Access Issues

Fix Excel File in Use and Locked for Editing Errors

Maira MehtabMaira Mehtab Nov 20, 2026 869 views

Question details

The user needs to regain editing access to an Excel file that appears to be locked by another user.

Fix Excel File in Use and Locked for Editing Errors
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.
Before you start

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.

Solution 1Recommended

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.

1
Close the workbook

Close the workbook in Excel on your device and confirm that all other users have closed it, including on other devices.

2
Find the lock file

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.

3
Remove the orphaned file

Only after confirming that nobody is editing the workbook, delete the matching ~$ lock file. Do not delete the actual workbook.

4
Reopen the workbook

Open the original workbook in Excel and check whether you can edit it.

Remove an Orphaned Excel Lock File
Shared cloud files: For a SharePoint or OneDrive file, check its status in the web library and allow time for the lock to expire. Do not delete temporary files from a synced folder while anyone may be editing.
Free Microsoft Office alternative

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.

Open and edit spreadsheets with a familiar interfaceCompatible with Microsoft Excel XLS and XLSX formatsMove existing workbooks into WPS Office without changing your workflowFree and lightweight for everyday spreadsheet tasks
microsoft office alternative - wps office

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.