How to Fix Excel Files Opening as Read-Only for Domain Users
Question details
Regular domain users are finding that shared Excel workbooks open in read-only mode, preventing them from saving changes, even though the file is not explicitly set as read-only in its basic properties.

- Product
- Microsoft Excel
- Device & OS
- Windows
- Scenario
- Accessing and collaborating on shared Excel workbooks over a corporate network or domain environment.
- Observed behavior
- The Excel file opens in read-only mode for regular domain users, while network administrators can open and edit the file normally.
Ensure you are logged in with an administrator account on the domain controller or have sufficient privileges to modify network share and NTFS security permissions for the affected files.
Review and Modify NTFS and Share Permissions
Adjust the security permissions of the file or folder to ensure regular domain users have the correct rights to modify the workbook.
Network files are governed by both Share permissions and NTFS security permissions. The most restrictive permission applies. If a user only has Read access in either setting, the Excel file will open as read-only.
Administrators often have Write access through a separate administrative group, which is why they do not experience the issue.
Locate the affected Excel workbook or its parent folder on the network drive, right-click it, and select Properties.
Navigate to the Security tab. Click on Advanced to view the effective permissions for the regular domain users or user groups.
Click Edit to change permissions. Select the affected user group and check the boxes to Allow 'Modify' and 'Write' access. Click Apply and OK.
Switch to the Sharing tab, click Advanced Sharing, and then click Permissions. Ensure the regular domain users group also has 'Change' or 'Full Control' allowed.

Check Internal Workbook Protection Settings
Verify that the Excel workbook itself has not been marked as final or protected via document-management policies.
Try WPS Office for Seamless Spreadsheet Management
If you frequently encounter complex permission locking issues or compatibility problems with Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for opening, editing, and sharing standard Excel workbooks across your organization.
- 1. Download and Install: Download the free WPS Office installer from the official website and follow the simple on-screen instructions to install it.
- 2. Open Your Network File: Launch WPS Spreadsheet, go to Menu > Open, and navigate to your shared network drive to select the workbook.
- 3. Edit and Save Seamlessly: Make your necessary edits and save the file. All formulas, formatting, and structures remain perfectly compatible.

Frequently Asked Questions
Why does my Excel file keep opening as Read-Only for some users but not others?
This is typically caused by NTFS security or network share permissions. An administrator might belong to an admin group with full Write access, while regular domain users belong to a group that has only been granted Read access to the network folder.
How do I turn off 'Mark as Final' in an Excel file?
Open the file in Excel, go to File > Info, click the Protect Workbook dropdown, and select 'Mark as Final' to toggle it off. A yellow banner may also appear at the top of the sheet when opened; clicking 'Edit Anyway' will also remove this status.
Can hidden Windows file attributes cause a workbook to be Read-Only?
Yes. If the file was moved or copied from a location that applied a Read-only file attribute at the Windows system level, it will restrict editing. Right-click the file, select Properties, and ensure the 'Read-only' checkbox under the General tab is unchecked.
How do I check effective NTFS permissions for a specific user?
Right-click the folder or file, select Properties, and go to the Security tab. Click Advanced, then navigate to the Effective Access tab. Select the specific user from the directory and click 'View effective access' to see exactly what permissions they have.




