the current excel file is locked for editing

Note: When you Reopen the file, by clicking Yes to edit you’ll be able to make changes. On reopening the file, a message on the dialogue box will ask to open as read-only? Below is the popup depicting it. Yes, there is an option to provide a password, we will get to it later.ģ. On clicking General Options you get a dialogue box as follows Press F12 ( shortcut to Save As ) > Click on tools (next to save option ) > General Options > Tick the read only > Ok. Click on File > Info > Protect Workbook > Always open Read-only. Open the file you want to set as Read-only.Ģ. This does not provide security but does avoid the chance of unintentional changes. To prevent any accidental changes, you can set up your workbook to Read-only. The three types are Read-only, Password to open, Password to modify. They are as follows : FILE LEVEL PROTECTION This gives you the power to safeguard your files by locking the Excel file with a password so that users cannot open or modify it. 3.1.2 How do I know if the cells are locked?.3.1.1 Step to Protect Cells/ Ranges within a Worksheet.3.0.2 How do I know if the Worksheet Is Protected?.2.1.2 How do I know if the Workbook Is Protected?.1.3.2 How do I know if the file is marked as final?.1.2.4 How do I know if the file is Password Protected for modifying?.1.2.3 Steps to set Password – modify the file.1.2.2 How do I know if the file is Password Protected?.1.2.1 Steps to set Password to open the file.1.1.2 How do I know if the file is Read-only?.

The current excel file is locked for editing