How to Save an Excel Workbook When Another User Is Editing It
Question details
The user is unable to save changes to an Excel workbook because another user currently has the same file open for editing on a shared network folder.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Two or more users are accessing and attempting to modify the same Excel file stored on a traditional shared network drive.
- Observed behavior
- Excel displays a prompt stating that the workbook cannot be saved because it is locked or currently being edited by another user.
Verify the network path of the shared file and check with your colleagues to identify who currently has the file open. Avoid forcefully closing the Excel application to prevent losing your unsaved work.
Save a Separate Copy and Merge Edits
The safest immediate action to prevent overwriting your colleague's work or losing your own progress is to save your current document as a new file.
Go to 'File' > 'Save As' and choose a destination, either on your local drive or within the same shared network folder.
Append your name or the current date to the file name (e.g., 'Budget_Q4_YourName.xlsx') and click 'Save'.
Wait for the other user to finish and close the original file. Once unlocked, open both versions side-by-side and manually copy your updated data into the original workbook.
Move to SharePoint, Teams, or OneDrive for Co-authoring
Prevent future file locking issues by migrating away from traditional shared network drives and utilizing modern cloud storage for real-time collaboration.
Review Group Policy Settings for Network Drives
If users are not receiving the standard 'read-only' warning when opening a file that is in use, network administrators should verify Group Policy configurations.
Collaborate in Real-Time with WPS Office
Avoid file locking and 'read-only' errors completely by using WPS Office. With built-in cloud collaboration, multiple users can co-edit the same spreadsheet simultaneously without overwriting each other's work.
- 1. Open Your Spreadsheet in WPS: Launch WPS Office and open your existing .xlsx workbook.
- 2. Save to WPS Cloud: Click the 'Share' button in the top right corner and save the document to your secure WPS Cloud space.
- 3. Invite Collaborators: Generate a sharing link and send it to your colleagues, ensuring you set their permissions to 'Editor'.
- 4. Co-edit Simultaneously: As your team opens the link, you will see their cursors and edits in real-time. All changes are saved automatically without locking the file.
Frequently Asked Questions
Why does Excel say a file is locked for editing by 'another user' when I am the only one using it?
This usually happens if Excel crashed previously and left a background process running, or if a temporary hidden lock file (starting with `~$`) was not automatically deleted when the file was last closed. You can fix this by ending background Excel processes in Task Manager or deleting the temporary file in the network folder.
Can I force Excel to unlock a file on a network drive?
As an end user, you cannot force an unlock unless you ask the person currently editing the file to close it. However, network administrators can use the 'Computer Management' tool on the hosting server to view 'Open Files' and forcefully close the session if the user is unavailable.
Does the legacy 'Share Workbook' feature fix network file locking?
The legacy 'Share Workbook' feature does allow simultaneous edits on a network drive, but it is highly prone to data corruption, conflicts, and file bloat. Microsoft strongly recommends against using it and suggests modern co-authoring via OneDrive or SharePoint instead.
How do I find out exactly who has the Excel file open?
Normally, the locked notification will display the username of the person who has the file open. If it generically says 'another user', the network might not be passing the user metadata correctly, or the file is open in a non-Office application. Administrators can verify the exact active user through the server's share management console.
