In the Password to modify box, enter a password and click OK. Click on the Tools button and click General Options.ĥ. For a better protection, protect a sheet.Ĥ. Users can still save changes by creating a new copy of the workbook. This example shows you how to make your workbook read-only.

How to Unprotect Excel Workbook without Password.

How to Disable Protected View for Office 2010 to Enable Editing.

Forgot Excel Workbook 2010/2013 Password.

How to Unlock Encrypted Excel Spreadsheet without Password.

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

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. Now you have been able to edit excel file and make any changes to worksheet or workbook.Ĭase 2: Excel file becomes read-only recommended by “Save As” 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.

I forgot my excel worksheet password