Fix Office Files on Network Drive Not Opening as Read-Only
Question details
Users need to enforce read-only notifications for subsequent users opening the same Office file on a network drive to prevent overwritten changes.
- Product
- Microsoft Office 2021 (Excel, Word)
- Device & OS
- not provided
- Scenario
- Multiple users are accessing the same Excel or Word file stored on a mapped local network server.
- Observed behavior
- Later users do not receive a read-only notification when opening an already-opened file, allowing simultaneous edits that overwrite one another.
Ensure you have administrative access to the network server's Group Policy Management console and the shared folder's permission settings.
Verify Group Policy Settings for Mapped Drives
Ensure the Group Policy action for mapped network drives is set correctly so active file locks are not dropped or ignored.
If a mapped drive is configured to 'Replace' instead of 'Update' in Group Policy, the drive connection refreshes periodically in the background. This brief disconnection can drop the temporary owner file lock (the ~$ temp file), causing Office to think the file is closed and allowing secondary users to open it with full edit rights.
Log into your Windows Server as an administrator and open the Group Policy Management Console (GPMC).
Go to User Configuration > Preferences > Windows Settings > Drive Maps.
Right-click the mapped drive policy causing the issue and select Properties. Ensure the Action dropdown is set to 'Update' rather than 'Replace'.
Click Apply, then OK. Open Command Prompt on the client machines and run 'gpupdate /force' to apply the new settings immediately.
Disable Legacy Shared Workbook Features
Turn off legacy shared workbook settings in Excel that might bypass the standard read-only lock.
Enforce Strict File and Folder Permissions
Check network file permissions to ensure users have appropriate read/write access without overriding ownership properties.
Use WPS Office for Reliable File Management
If Microsoft Office continues to experience file-locking and overwritten changes on your local network drive, consider switching to WPS Office. It provides robust file handling, familiar user interfaces, and excellent format compatibility, allowing your team to view and edit files securely.
- 1. Install WPS Office: Download and install the free version of WPS Office on the client machines.
- 2. Access the Network Drive: Navigate to your mapped network drive using the standard Windows File Explorer.
- 3. Open Files Reliably: Double-click your .xlsx or .docx files to open them in WPS Office, which respects standard Windows file-locking protocols.
Frequently Asked Questions
Why isn't Excel locking my file on a mapped network drive?
This usually happens if the Group Policy for the mapped drive is set to 'Replace' instead of 'Update', which briefly disconnects the drive and drops the file lock. It can also occur if the user lacks permissions to create hidden lock files in the directory.
Does real-time co-authoring work on local network drives?
No, real-time co-authoring in Microsoft Office requires files to be hosted on a cloud service like SharePoint or OneDrive. Files on local network drives rely on traditional file locking, meaning subsequent users should only get read-only access.
Can I force a specific Excel file to always open as read-only?
Yes, you can configure a file to recommend read-only status. In Excel, go to File > Save As, click 'Tools' next to the Save button, select 'General Options', and check the 'Read-only recommended' box.
