Fix Excel Allowing Multiple Users to Edit a Network File
Question details
Multiple users are able to edit the same Excel workbook stored on a network share simultaneously, leading to save conflicts instead of triggering the expected read-only lock.
- Product
- Microsoft Excel
- Device & OS
- Windows Server 2019
- Scenario
- Users in a department access shared Excel workbooks through mapped network drives on a file server.
- Observed behavior
- Excel fails to lock the file for the first user. Subsequent users do not receive a 'file in use' prompt, allowing concurrent editing that results in overwritten data or save conflicts.
Ensure all users in the department are running the exact same version and update channel of Microsoft Excel, and confirm whether the problem occurs exclusively with Excel files or affects other applications like Word.
Investigate Windows File-Server Locking Settings
Verify that the Windows Server hosting the network share is properly handling open file locks and permissions for temporary owner files.
When an Excel file is opened, it attempts to create a temporary owner file (starting with '~$') in the same directory to signal that the file is locked. If folder permissions or server caching configurations block this process, locking will fail.
Navigate to the shared folder on the Windows Server, right-click, and select Properties. Under the Security tab, ensure that users have both 'Read' and 'Write' permissions so Excel can create and delete temporary lock files.
Open Computer Management on the Windows Server. Go to System Tools > Shared Folders > Open Files to verify if the server is accurately registering the Excel file as open when a user accesses it.
Have all users close the affected workbook. In Windows Explorer, enable 'Show hidden files' and delete any residual files starting with '~$' that match the workbook's name.
Test and Migrate to a SharePoint Library
If local network drives continue to fail at locking files reliably, use SharePoint Online to enforce mandatory check-outs.
Try WPS Office for Seamless and Free Document Collaboration
If persistent network file-locking issues in Microsoft Excel disrupt your team's workflow, consider switching to WPS Office. It provides robust local file handling, excellent Microsoft format compatibility, and built-in cloud alternatives to completely avoid save conflicts.
- 1. Download the Installer: Visit the WPS Office website and download the free version for your operating system.
- 2. Install WPS Office: Run the setup file. The lightweight installation takes only minutes to complete.
- 3. Open Your Network Files: Launch WPS Spreadsheets and open your .xlsx files directly from your mapped network drive securely.
Frequently Asked Questions
Why does Excel create temporary files starting with '~$' on the network drive?
These are owner files created by Excel to indicate that the workbook is currently open and locked by a specific user. If network permissions prevent Excel from creating these files, other users will not receive the read-only prompt.
Does Excel's real-time co-authoring work on mapped network drives?
No. Real-time co-authoring is only supported when the file is hosted on OneDrive, OneDrive for Business, or SharePoint Online. Files on traditional Windows Server network drives rely on standard file locking.
Can I manually force an Excel file to open as read-only?
Yes. You can right-click the file in Windows Explorer, select Properties, and check 'Read-only'. Alternatively, you can open the file in Excel, go to Save As > Tools > General Options, and set a 'Password to modify'.
Is this simultaneous editing issue caused by my Excel version?
While mismatched Excel versions or update channels can sometimes cause erratic locking behavior, the issue on network drives is most commonly related to Windows Server SMB configurations, folder permissions, or file caching.
