passper

5 Ways to Remove Read Only from Excel 2019/2017/2016/2013/2010/2007

author_icon Ronnie Barnes time_icon Last updated: Aug 15, 2019 03:27 pm tips_icon Excel

Once you have finished editing the workbook, you can place read-only restrictions on it and anyone you share it with will be able to read it, but they will not be able to edit the document in any way. But read-only can be a hindrance when you really need to make changes to the document. Perhaps a friend or colleague shared the read only Excel workbook with you and neglected to share with you how to remove this restriction.

Excel can be set read only with various options. In this article, we list all the possible cases and its related solutions to let you know how to remove read only from Excel in various cases.

1st Case: Excel is Made Read Only by "Mark as Final"

One of the reasons why the Excel document you have is read-only is because it has been marked as final by the editor. If this is the case, you should see a message on top of the document saying "MARKED AS FINAL".

When a document is marked as final, it will essentially be impossible to make any changes to it. You can't type, edit or even proof the document in this state. But it is also easy to remove. Simply click on the "Edit Anyway" button at the end of the message and you'll be able to disable the read only in Excel.

edit anyway

2nd Case: Excel File Becomes Read Only Recommended by "Save As"

Another situation to know that an Excel document is in read-only mode is that you will be prompted to open the document in read-only mode unless you need to make changes to it. If you don't want to make changes to the document, simply click "Yes". And if you would like to edit the document, simply click "No" to open it.

If you want to unlock excel file from read only, follow these simple steps:

Step 1: When you first open the Excel document and you get the message offering you three options to open the read-only document, simply click on "Yes" to open the file in read-only mode.

open read only excel

Step 2: If you make any changes to the content on the document and attempt to save the changes, a new message will appear prompting you to save a copy of the file and rename it. Click on "OK" to open the "Save A" dialogue and then click on "Tools > General Options".

general options excel

Step 3: In the "General Options" dialogue box that appears, uncheck "Read-Only recommended" and then click "OK".

read only recommended

Step 4: Back on the "Save As" dialogue, click on "Save". This will make a copy of the original excel file. The copied file will not be read-only and you may then continue to edit it as you wish.

This will remove the read-only restriction from the Excel document.

3rd Case: Excel Worksheet and Workbook Structure is Locked and Read Only

If the Excel file is in Read-Only mode because the worksheet or workbook structure is locked, you may be able to remove read-only restriction from Excel if you know the password. Here's how to do it:

Step 1: Open the protected Excel file, so you can view all the worksheets and content on it.

Step 2: Click on "Review" in the main menu and then select "Unprotect Sheet" under "Changes". Enter the password to complete the process.

unprotect sheet

Step 3: If it is the workbook structure that is protected, click on "Unprotect Workbook" and then enter the password to remove the restriction.

unprotect workbook

Save the document and the read-only restriction will be removed.

4th Case: Set Modify Restrictions on Excel to Make it Read Only

Sometimes, when you open an encrypted Excel file, you will be required to enter the password for write access or open read only. Tap on 'Read Only' option and the Excel file will be restricted to modify and read only. Follow these steps to disable read only in Excel:

Step 1. Save the current read only Excel file by clicking on File > Save As.

open read only excel file

Step 2. Just save it as a different Excel document and click on 'Save' to proceed.

save as excel file to remove read only

You can now open the copy of the Excel file and make changes on it.

Bonus Tip: Remove Read Only from Excel without Password (For All Cases Above)

If you want to remove Excel 'read only' mode set by all options in one click withput password, then one of the best ways to make it possible is using an Excel password remover tool like Passper for Excel.

Passper for Excel is a tool that allows you to remove read only set by Mark as Final and Save As, remove restriction on Excel Worksheet and Workbook Structure and remove the opening password on any locked Excel document.

It is therefore a very handy tool to have when you can't open or edit a read only Excel document. The following are just some of its features:

Passper for Excel: Remove Read Only from Excel in 2 Seconds:

  • All Cases Covered: Remove or disable read only from Excel in all possible cases.

  • 4 Recovery Methods: Passper for Excel utilizes four different attack modes to renove the opening password which makes it one of the most effective tools for this task.

  • Highest Recovery Rate: Advanced algorithm guarantees the 100% removing rate.

  • Easy to Use: It is also very easy to use. With it, you can recover the opening password in a few simple steps and remove restrictions in a single click.

Free Download for Win 10/8.1/8/7/XP

How to Unlock Excel File from Read-Only with Passper for Excel

Here's how to use Passper for Excel to remove read-only restrictions from an Excel document:

Step 1: Download and install Passper for Excel on to your computer and then open it. On the main windows, select "Remove Restrictions".

remove restrictions step1

Step 2: Click on "Add" to import the restricted document into Passper.

remove restrictions step2

Step 3: Once the document has been successfully added onto the program, click on "Remove" and any read only restrictions on the Excel document will be successfully lifted.

remove restrictions step3

How to Remove Opening Password from Excel Using Passper for Excel

If on the other hand you are unable to open the Excel document because there is an opening password on it, Passper for Excel can help you recover the opening password you need. Here's how to do it:

Free Download For Win 10/8.1/8/7/XP

Step 1: Launch Passper for Excel on your computer and then select "Recover Passwords". Click "Add" to browse your computer for the password protected file to add to the program.

recover password step1

Step 2: Once the file is added in Passper, the next step is to select the attack mode that helps you unlock the document. Each of the attack modes has its own strengths and weaknesses and the one you choose will depend on how much information you have on the password. For example, you can choose the Dictionary Mode or "Brute Force Attack" mode if you don't know anything about the password.

choose attack type excel

With the attack mode selected, the program will begin recovering the password for the Excel file uploaded. This process may take some time depending on the strength of the password and the attack mode you selected.

Step 3: When the process is complete, the password will be displayed on the next window. You can use it to unlock the Excel document.

recover password step3

Conclusion

The above are the best 5 ways for you if you don't know how to remove read only from excel. Keep in mind that there may be several reasons why you are unable to access the Excel document although one of the most common is when the document is "marked as final". Passper for Excel allows you to easily access the document regardless of the restrictions placed on it including a document that is password protected.

user

By Ronnie Barnes to Excel

Posted on Jun 10, 2019 ( Updated: Aug 15, 2019 )

Ronnie Barnes, a blogger with more than 5-year experience in writing tips about password recovery for Windows and office files.