How to Remove Read-Only Protection From an Excel File via Properties and Folder Permissions

You cannot save changes to an Excel file because it opens as read-only. This protection can be set directly on the file or inherited from its folder. The file’s properties and Windows security settings control this access. This article explains how to remove read-only protection using file properties and folder permissions.

Understanding Read-Only Protection in Excel

A file opening as read-only can stem from several sources. The most common is the read-only attribute, a simple file property in Windows. Another source is file-level protection within Excel, like the Mark as Final feature. The most restrictive source is NTFS permissions set on the file or its parent folder, which dictate user access rights. You need to check these areas in a specific order to find and remove the correct restriction.

Steps to Remove Read-Only Protection

Method 1: Check and Remove Excel File Protection

First, verify if the read-only state is controlled by Excel’s own features. Open the file in Excel, even if it opens in read-only mode.

1. Inspect the Protect Workbook status
   Go to the File tab and select Info. Look at the Protect Workbook section. If it says “Marked as Final,” this is causing the read-only alert.
2. Remove the Mark as Final status
   Click the Protect Workbook button and select Mark as Final again to toggle it off. A confirmation message will appear.
3. Check for other protection
   If Protect Workbook shows options like Encrypt with Password, the file may be password-protected. You must know the password to remove this protection from within the File > Info menu.

Method 2: Clear the Read-Only Attribute in File Properties

If Excel shows no internal protection, the read-only attribute on the file itself is likely set. Close Excel completely before proceeding.

1. Locate the file in File Explorer
   Open Windows File Explorer and navigate to the folder containing your Excel file.
2. Open the file’s Properties
   Right-click the Excel file and select Properties from the context menu.
3. Uncheck the Read-only attribute
   In the General tab, find the Attributes section. If the Read-only checkbox has a solid black square, the attribute is partially applied. Click the checkbox once to clear it completely, ensuring the box is empty. Click Apply and then OK.

Method 3: Modify Folder and File Permissions in Windows

If the file still opens as read-only, Windows security permissions are restricting your write access. You must adjust these permissions for your user account.

1. Open the file’s Security properties
   Right-click the Excel file and select Properties. Go to the Security tab.
2. Check your user permissions
   In the Group or user names list, select your current Windows username. The Permissions pane at the bottom shows your effective rights. If Write or Full Control is not allowed, you need to modify permissions.
3. Open the Advanced security settings
   Click the Advanced button near the bottom of the Security tab.
4. Take ownership if necessary
   If the Owner field at the top is not your user account, click Change next to it. Type your username, click Check Names, and then OK. Check the box for “Replace owner on subcontainers and objects” and click Apply.
5. Edit your user’s permissions
   In the Advanced Security Settings window, find and select the entry for your user in the permission entries list. Click Edit. In the new window, under Basic permissions, check the box for Full Control. This automatically checks all other boxes. Click OK through all open windows.

Common Mistakes and Limitations

File Opens Read-Only From a Network or SharePoint Location

Files stored on SharePoint or a network drive often open in read-only mode if another user has the file open. Check with your team to ensure no one else is editing the document. For SharePoint files, you may need to check out the file from the web interface to gain edit rights.

The Read-Only Checkbox in Properties Is Grayed Out

If you cannot change the read-only attribute, the file likely has restrictive permissions. You must first take ownership of the file using Method 3, Step 4, before you can modify its basic attributes.

Excel Prompts for a Password on Opening

This indicates the file has a password to open, which is different from read-only protection. You cannot remove this password without knowing it. The methods in this article only address the read-only attribute and permissions, not encryption passwords.

File Protection Methods Comparison

Item	Read-Only Attribute (File Properties)	NTFS Folder Permissions	Excel “Mark as Final”
Primary Control Location	Windows File Explorer File Properties	Windows Security Tab	Excel File > Info Menu
User Override Possible	Yes, user can uncheck the attribute	Only with admin rights or ownership	Yes, user can click “Edit Anyway”
Effect on Other Users	Applies to all users on the same PC	Can be set per user or group	Applies to all users who open the file
True Security Level	Very low, easily changed	High, part of Windows security	Low, notification only

You can now save changes to your previously locked Excel files. Start by checking the file’s internal protection status in the File > Info menu. If problems persist, use the Security tab to take ownership and grant Full Control permissions. For advanced management, use the icacls command in the Windows Command Prompt to reset permissions on multiple files at once.