Handling “Someone else has this file open” when using Legacy Shared Workbooks.

The prompt “‘Workbook.xlsx’ is locked for editing by ‘User Name’. Open ‘Read-Only’ or click ‘Notify’ to be notified when it is available” appears when you open a file that uses legacy network file-locking. This occurs either because the spreadsheet is stored on a standard shared network drive (SMB) that lacks modern co-authoring, or because the file was configured using Excel’s obsolete “Shared Workbook (Legacy)” architecture.

Quick Fix

If the user listed in the prompt has actually closed the file, the file server still holds an orphaned lock handle. To clear it, have an IT administrator close the open session via Computer Management > Shared Folders > Open Files on the file server, or delete the hidden owner lock file (~$Workbook.xlsx) in the folder directory.

---

Step 1: Differentiate Network File Locks from Legacy Shared Workbooks

Before changing any settings, confirm which mechanism is locking your workbook:

1. Standard Network Share (Non-Coauthored):
   • If the file is stored on a local network drive (like Z:\Shared\Sales.xlsx) without Microsoft 365 cloud hosting, Excel enforces exclusive file access. Only one user can open the file with write permissions at a time. Everyone else receives the “locked for editing” prompt.
2. Legacy Shared Workbook:
   • If the title bar includes the word [Shared] next to the file name, the file is using an older Excel feature from the 1990s designed for multi-user editing. This feature is notoriously unstable, prone to file corruption, and frequently misreports who is using the file.

---

Step 2: Remove Stale Users from a Legacy Shared Workbook

If the file is marked as [Shared], you can manually disconnect users whose sessions crashed or remained open overnight.

1. Open the file (click Read-Only if prompted).
2. Go to the Review tab on the ribbon.
3. Look for the Share Workbook (Legacy) button.
   (If you cannot find it, search for “Share Workbook” using the search box at the top of Excel).
4. In the dialog box, click the Editing tab.
5. Under “Who has this workbook open now”, review the list of names.
6. Select the user who is no longer active and click Remove User.
7. Click OK. Save the file. The lock is released, and full editing rights return.

If a legacy file continues to strip modern Excel functionality or disables cloud features, see Troubleshooting “AutoSave” being disabled automatically..

---

Step 3: Clear “Ghost” Owner Locks on Network File Shares

When a user opens an Excel file across a shared network drive, Excel creates an invisible temporary lock file in that same folder. For example, opening Report.xlsx creates a hidden file named ~$Report.xlsx. If Excel crashes, this lock file may remain behind, causing the file server to falsely report that the user still has it open.

1. Open Windows File Explorer and browse to the folder containing the file.
2. Click View > Show > Hidden items.
3. Look for a file starting with ~$ that matches your workbook’s name.
4. If the listed user has closed Excel, select the ~$ file and press Delete.
5. If Windows reports the file is in use and refuses deletion, the file server’s operating system is maintaining the lock.
6. Server-Side Release:
   • On the Windows File Server hosting the share, open Computer Management (compmgmt.msc).
   • Navigate to System Tools > Shared Folders > Open Files.
   • Find the locked file in the list, right-click it, and select Close Open File.

For an in-depth walkthrough on eliminating persistent owner lock artifacts, see “The file is locked for editing”: How to kill “Ghost” owner files (~$filename)..

---

Step 4: Permanent Fix: Migrate to Modern Co-authoring

The Legacy Shared Workbook feature has been deprecated by Microsoft due to chronic reliability failures. The only permanent way to eliminate file-locking prompts is to disable the legacy sharing engine and move the file to SharePoint or OneDrive.

How to Modernize the Workbook:

1. Ensure everyone exits the file.
2. Open the file and go to the Review tab > Share Workbook (Legacy).
3. Uncheck the box that reads “Use the old shared workbooks feature instead of the new co-authoring experience”.
4. Click OK. When warned that this will remove the file from shared use, confirm Yes.
5. Go to File > Save As and change the file format to standard Excel Workbook (*.xlsx) if it was an older format.
6. Move the newly unshared file into SharePoint Online or OneDrive for Business.

Once stored in SharePoint, multiple users can open and edit the spreadsheet at the same time without seeing “locked for editing” prompts.

If you are temporarily trapped in Read-Only mode and cannot save structural updates to the existing path, see Recovering data from “Read-Only” files that refuse to save as a new copy..

---

Summary Checklist

• Check if the title bar displays [Shared] to see if the file uses legacy shared workbook logic.
• Remove inactive or hung users via Review > Share Workbook (Legacy).
• Delete lingering ~$ hidden lock files from the network directory.
• Have a system administrator close stale handles via Open Files in Computer Management on the server.
• Turn off legacy sharing entirely and migrate the workbook to SharePoint Online for true real-time co-authoring.