Surely, read-simply excel file could prevent adventitious changes on it. Only read-only mode could be removed or disabled equally you wish someday when you desire to edit excel file?

I don't know. But I think some options you take used to set excel workbook read just, would be able to remove this setting always. So that y'all tin 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 tin do to remove read just status from Excel file.

  • Case 1: Excel file is made read-only by "Mark every bit Terminal"
  • Case 2: Excel file becomes read-only recommended past "Save As"
  • Instance 3: Excel file is restricted modify and read just
  • Case four: Worksheet and Workbook construction is locked and read merely

Example 1: Excel file is fabricated read-only by "Mark as Final"

While you open an excel file that has been marked every bit terminal, you would encounter a message bar at the top of sheet window. To remove read only from excel file, you lot just need to click on "Edit Anyway" push button on message bar.

click edit anyway to remove read only in excel file

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

Case ii: Excel file becomes read-only recommended by "Save Equally"

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

open excel file as read only

Now if you make any changes on the excel file, and desire to save, in that location would be a message that prompts y'all again to save a re-create of the file and rename it.

ane. Click OK and open up Save Equally dialog. And then click "Tools > Full general Options" in Save As dialog.

choose to save read-only excel file as

2. Uncheck "Read-but recommended"and click OK.

change general options to disable excel file read only

3. Back to Relieve Every bit dialog and click "Salve" button to make a copy of original excel file. From then on, the copied Excel file would be non read-just and could exist used instead of original ane. It means y'all have disabled read-simply in Excel file.

Case iii: 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" push to open excel file as read only.

open read-only excel file without modify password

Information technology seems y'all cannot exercise any changes on it, but you can save the read-just excel file as another i to remove modify countersign. So remove read only in excel file.

1. Click File > Salvage As, and click Salve button in pop-up Relieve As dialog.

save as excel file to remove read only mode

ii. Click OK to save excel file to replace the read-just 1.

Case 4: Worksheet and Workbook construction is locked and read simply

While your excel file is read only and you know it is because worksheet and workbook structure is protected, it will be like shooting fish in a barrel or difficult to disable read only. Nosotros don't know.

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

1. Open your excel file in MS Excel and you tin view all worksheet and its content.

2. Click Unprotect Sheet under Review > Changes group, and enter countersign to unprotect sheet 1 by ane.

remove read only in excel sheet

three. Click Protect Workbook in the same location and type password to unprotect workbook structure and windows.

disable remove only in workbook structure of excel file

4. Save excel file and read-but manner would be removed from excel file.

Simply if yous don't know protected password, disabling read only in Excel file would be a footling difficult unless y'all could find a utility to directly remove countersign protection from excel workbook, such as iSunshare Workbook Unprotect Genius, which could directly and easily remove worksheet/workbook protected password with but i click.

Tips:

Probably your excel file is also protected with open password now besides to a higher place edit restrictions. So just opening the excel file is a hard thing, not to say removing read only fashion in excel file. But if you want to disable excel file read merely, removing or recovering excel file countersign to open up the countersign protected excel file is necessary at first. Otherwise, you lot just could let excel file read-just all the time.

Related Articles:

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

  5 people found this commodity useful