passper

[100 Working] 6 Ways to Disable Read Only in Excel 2016

author_icon Ronnie Barnes time_icon Last updated: Aug 13, 2019 02:56 pm tips_icon Excel

The Excel file can be set to read only mode when the file is marked as final, when it is saved as read only or when the Worksheet or Workbook Structure is locked, etc. Yet, as useful as read-only can be, it can also be a hindrance especially when you don't know how to remove the restriction.

In this article, we are going to be looking at some of the ways to disable read only in Excel 2016 whether you have the password or not.

Part 1. Common Method to Disable Read Only in Excel 2016 without Password

Disabling the Read Only feature in Excel can be difficult even impossible when you don't know the password used to place the restriction. Yet, there are certain tools in the market that can help you remove read only in Excel 2016 easily. One of the best is Passper Excel Password Remover.

The following are just some of the features Passper for Excel has to offer:

  • It supports to remove all types of read only mode in Part 2 without password.

  • Remove opening passwords and remove read only in Excel 2016 worksheet/workbook protection without affecting the data on the document.

  • Unlock excel documents when forgot the password, can't copy the data on the worksheet or workbook, can't print the worksheet/workbook or you can't edit the content on the document.

  • It is also very easy to use, allowing you to remove the read only in a single click.

  • Supports all versions of Excel documents, including Excel 96-Excel 2019.

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

Here's how to use Passper Excel Password Remover to remove read only on any Excel document:

Step 1: Download and install Passper Excel Password Remover on to your computer and then launch the program.

select remove restrictions

Step 2: Click on "Remove Restrictions" and then click "Add" to browse for the restricted Excel document into the program.

add excel worksheet  

Step 3: When the file has been added to the program, click "Remove" and Passper will begin immediately removing the restrictions from the file. In a few seconds, you will be able to access the Excel 2016 document without any restrictions.

unprotect excel sheet 2016

Part 2. 5 Different Cases to Disable Read Only in Excel 2016

There are mainly 5 different cases when your Excel 2016 is marked as read only and its corresponding solution to disable the read only feature.

Case 1: When the Document is Made Read-only During Saving

You can use the "Save As" feature as outlined below to disable read only in Excel 2016:

Step 1: Begin by opening the Excel Workbook and then enter the password if you are required to. Click on "File > Save As" and then choose a suitable location on your computer to save the file.

Step 2: Click on the drop-down arrow next to the "Tools" button and then select "General Options".

excel general options

Step 3: Delete the password that appears in the "Password to Modify" box and click "OK" to lift the read-only restriction. Click "OK".

password to modify

Step 4: Finally, click "Save" to complete the process.

Case 2: When Document is Marked As Final

Marking your Excel 2016 document as "Final" can place a read-only restriction on the document. Here's how to disable this restriction in a document that has been marked as final.

Step 1: Open the restricted Excel 2016 document on your computer.

Step 2: At the top of the document, you should see the "Edit Anyway" button. Click on it and the read-only restriction will be lifted, allowing you to edit the document.

edit anyway

Case 3: When Worksheet or Workbook Structure is Locked

Read-only restrictions can also occur when the Excel 2016 document's author has locked the worksheet or workbook structure, preventing you from being able to edit the worksheet. In this case, you can resolve the issue in the following simple steps:

Step 1: Open the Excel document with the read-only restriction and then click on "Review > Unprotect Sheet".

unprotect sheet

Step 2: Enter the password in the box provided and then click "OK" to lift the restriction.

Case 4: When the Document has a Read-Only Status

You can disable read only in excel 2016 using the File properties option in Windows File Explorer. Here's how to do it:

Step 1: In File Explorer, navigate to the restricted Excel file. Right-click on the document and then select "Properties" from the options presented.

Step 2: Uncheck "Read Only" under the "Attributes' section and click "OK" to disable the read only restrictions.

excel properties read only

Case 5: When the Excel 2016 Document Needs a Password

When you need to enter a password to access and edit the Excel 2016 document, you can follow these simple steps to lift this restriction:

Step 1: Begin by opening the Excel 2016 document you want to disable the read only feature.

Step 2: When the password box appears, click on "Read only" instead and the document will open in Read-Only mode.

open read only excel file

Step 3: Now click on "File> Save As" and enter a different filename. Click "Save" to save a new copy of the original file.

save as excel file to remove read only

The new file created will replace the read-only document and will not have any of the restrictions on the original.

The above solutions make it easy for you to disable read only in excel 2016 whether you have the password or not. Choose the method that best suits your needs and particular situation. Let us know if you are able to lift the read-only restriction in the comments section below.

user

By Ronnie Barnes to Excel

Posted on Aug 13, 2019 ( Updated: Aug 13, 2019 )

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