Surely, read-only excel file could foreclose adventitious changes on it. But read-simply way could exist removed or disabled equally you wish anytime when y'all want to edit excel file?

I don't know. But I call up some options y'all have used to set excel workbook read only, would be able to remove this setting always. And so that yous can remove or disable read only in excel file. Now in this article, I will list several possible cases that make your workbook and worksheet read only and introduce how we can do to remove read simply status from Excel file.

  • Example 1: Excel file is made read-only by "Marking as Final"
  • Case 2: Excel file becomes read-simply recommended by "Salve As"
  • Case 3: Excel file is restricted modify and read only
  • Instance 4: Worksheet and Workbook structure is locked and read just

Case 1: Excel file is made read-only past "Mark equally Final"

While you open an excel file that has been marked every bit last, yous would meet a bulletin bar at the pinnacle of sheet window. To remove read only from excel file, y'all but demand to click on "Edit Anyway" button on message bar.

click edit anyway to remove read only in excel file

Now you have been able to edit excel file and make any changes to worksheet or workbook.

Case ii: Excel file becomes read-merely recommended by "Save As"

When a dialog appears and shows 3 options for you lot to choose after you double click the read-just excel file, but click "Yes" and you could open excel file in read-just mode.

open excel file as read only

Now if you brand whatsoever changes on the excel file, and want to salve, in that location would be a message that prompts you once again to relieve a copy of the file and rename it.

1. Click OK and open Relieve As dialog. Then click "Tools > Full general Options" in Save Every bit dialog.

choose to save read-only excel file as

ii. Uncheck "Read-only recommended"and click OK.

change general options to disable excel file read only

three. Dorsum to Save As dialog and click "Relieve" push to brand a re-create of original excel file. From and then on, the copied Excel file would exist not read-only and could exist used instead of original ane. It means you have disabled read-merely in Excel file.

Case 3: Excel file is restricted modify and read only

While you are trying to open excel file that is restricted modify, and a password is required for write access, instead of entering password, please just click "Read Only" button to open excel file as read only.

open read-only excel file without modify password

Information technology seems y'all cannot do any changes on it, but you lot tin relieve the read-only excel file equally another one to remove change password. So remove read but in excel file.

1. Click File > Save As, and click Save push button in popular-upwardly Save Equally dialog.

save as excel file to remove read only mode

2. Click OK to salve excel file to supersede the read-only i.

Instance 4: Worksheet and Workbook construction is locked and read only

While your excel file is read only and yous know information technology is because worksheet and workbook construction is protected, it will be easy or difficult to disable read but. We don't know.

If yous know the password that protect worksheet and workbook, remove read only in excel file would exist so piece of cake.

ane. Open up your excel file in MS Excel and you can view all worksheet and its content.

ii. Click Unprotect Sheet under Review > Changes group, and enter countersign to unprotect sheet one by i.

remove read only in excel sheet

three. Click Protect Workbook in the same location and blazon countersign to unprotect workbook structure and windows.

disable remove only in workbook structure of excel file

4. Salve excel file and read-only mode would exist removed from excel file.

But if you lot don't know protected password, disabling read only in Excel file would be a little difficult unless you could observe a utility to straight remove password protection from excel workbook, such equally iSunshare Workbook Unprotect Genius, which could directly and easily remove worksheet/workbook protected password with only one click.

Tips:

Probably your excel file is also protected with open password now as well above edit restrictions. Then only opening the excel file is a difficult thing, not to say removing read only mode in excel file. But if y'all desire to disable excel file read simply, removing or recovering excel file password to open the countersign protected excel file is necessary at first. Otherwise, you just could let excel file read-only all the time.

Related Articles:

  • How to Unlock Encrypted Excel Spreadsheet without Password
  • Forgot Excel Workbook 2010/2013 Password
  • How to Disable Protected View for Function 2010 to Enable Editing
  • How to Unprotect Excel Workbook without Password

  5 people found this article useful