How to Disable Read Only in Excel 2016

/ Posted by Shirley Howard to Excel / Follow @Shirley Howard

The Read Only feature in Excel, helps avoid accidental or intentional changes in Excel. Other users and authors who wish to edit the files have to alter it from read-only to editable. An Excel file can be marked Read Only for reasons including being saved in a locked USB flash drive when another user is working on the same document you are working on, it has been saved as Read Only, or it has been corrupted. This article outlines all details of the Read Only feature and explains how to disable read-only in Excel 2016.

excel 2016 read only

Excel users would want to disable the Read Only feature so that they can make changes to the file, and allow authorized access by multiple users. Below are 5 different cases to disable read-only in Excel 2016.

Case 1: Excel 2016 file is made read-only by “Mark as Final.”

Some users, through the File Menu on Excel, may have Marked the document as Final hence making it a Read Only file that cannot be edited. To disable Read Only on a file that has been set Mark as Final, follow the procedure below.

Step 1: Open the Excel File.

Step 2: Locate the Edit Anyway button under the ribbon and click it.

click edit anyway to remove read only

It is as simple as that.

Note: It usually has a yellow background a warning icon to its far left and the words ”An author has marked this workbook as final to discourage editing” next to it.

Case 2: Excel 2016 file becomes read-only recommended by “Save As.”

One of the advantages of Excel 2016 read only is, if you have an Excel file with a password to Modify, the file can only be opened in Read only if you don’t have its password. However, the changes the user makes can only be saved if they save the workbook with a different name or in a different file location. To do so, use the Save As feature as shown in the procedure below.

Step 1: Open the Excel workbook file in question, key in the password for write access and click OK.

Step 2: In the ribbon, click File > Saves As and choose a location, suitable for you, on your hard drive to save the workbook.

Step 3: In the Save As dialog box, Click the drop-down arrow next to the Tools button located at the bottom of the dialog box and Select General Options.

tools general options

Step 4: Delete the password under Password to modify options that appears In the General Options dialog box and check the Read-only recommended check box, then click Ok.

remove password to modify

Step 5: You’ll be directed back to the Save As dialog box. Click Save to save the Excel file.

With this procedure, you will have disabled read only on that workbook.

Case 3: Excel 2016 file is restricted modify and read only

An Excel file that cannot be modified and requires a password for access can still be accessed. Want to change Excel 2016 SharePoint read only? Follow the procedure below.

Step 1: Open the Excel workbook file in question.

Step 2:Click the Read Only button. This will open the file in Read Only mode.

open read only excel file without password

Step 3: In the ribbon, click File > Save As then proceed by clicking the Save button in the Save As dialog box.

save as excel file to remove read only mode

Step 4: Click Ok to save the workbook. This method ensures that you replace the original read only file.

Case 4: Excel 2016 Worksheet and Workbook structure is locked and read only

In certain situations, the author of the document can lock the cells and protect the workbook hence preventing users from making changes to it. Trying to edit the worksheet will have them end up with the dialog box shown below.

warning

To resolve this, follow the procedure below.

Step 1: Open the Excel file.

Step 2: In the ribbon, click the Review Tab, then click Unprotected Sheet and key in the password when prompted to do so.

unprotect sheet

Step 3: Save the document to remove Read Only.

Case 5: Excel 2016 file is on Read Only Status

Read Only can also be removed directly from File Properties via Windows File Explorer. Follow the procedure below.

Step 1: Navigate to the Excel file in File Explorer, right-click it then click Properties.

Step 2: Uncheck the “Read only” checkbox Under Attributes section.

Step 3: Click Apply then OK.

disable read only using file explorer

Extra Tip: How to Recover Forgotten Excel 2016 Password

PassFab for Excel is a great tool that allows users to recover passwords for Excel 2016 files by using multi-core CPU and GPU acceleration. To use this software to recover your forgotten Excel password, follow the procedure below.

Step 1: Download install and run this software on your computer.

Step 2: To import the encrypted file click the Add button located next to the Encrypted file option.

import file

Step 3: Select one of three attacks that will be used to recover the password: dictionary attack, brute force with Mask Attack or Brute Force Attack.

  • A. To use Dictionary Attack, download a dictionary or import it if you already have one.
  • B. Brute Force with Mask Attack allows you to whatever you remember about your password.
  • C. Brute Force Attack uses a combination of all possible characters to unlock your password.

Step 4: Click Start and wait for the password to be recovered.

searching file password

Step 5: Now the recovered password will be opened easily.

file password is found

Conclusion

Disabling Read Only on any Excel file is simple and can be done by following any of the procedures listed above. Some of the methods require that you key in your password. In case you have forgotten it, we recommend using PassFab ToolKit to recover it.

Comment

Product-related questions? Speak directly to our Support Team >>