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. Case 3: Excel file is restricted modify and read only It means you have disabled read-only in Excel file. From then on, the copied Excel file would be not read-only and could be used instead of original one.

Back to Save As dialog and click “ Save” button to make a copy of original excel file. Uncheck “ Read-only recommended“ and click OK.ģ. Then click “ Tools > General Options” in Save As dialog.Ģ. Now if you make any changes on the excel file, and want to save, there would be a message that prompts you again to save a copy of the file and rename it.ġ. When a dialog appears and shows three options for you to choose after you double click the read-only excel file, just click “Yes” and you could open excel file in read-only mode. Case 2: Excel file becomes read-only recommended by “Save As” Now you have been able to edit excel file and make any changes to worksheet or workbook. To remove read only from excel file, you just need to click on “ Edit Anyway” button on message bar. While you open an excel file that has been marked as final, you would see a message bar at the top of sheet window. Case 4: Worksheet and Workbook structure is locked and read onlyĬase 1: Excel file is made read-only by “Mark as Final”.Case 3: Excel file is restricted modify and read only.

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

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

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 only status from Excel file. So that you can remove or disable read only in excel file. But I think some options you have used to set excel workbook read only, would be able to remove this setting always. But read-only mode could be removed or disabled as you wish anytime when you want to edit excel file? Surely, read-only excel file could prevent accidental changes on it.

How to enable editing in excel on ippad