Click File > Save As, and click Save button in pop-up Save As dialog. Click OK to save excel file to replace the read-only one. While your excel file is read only and you know it is because worksheet and workbook structure is protected, it will be easy or difficult to disable read only.
Excel spreadsheets may be Read Only due to their location. If the spreadsheet is on a network folder and you do not have appropriate network permissions to make make changes in the folder, the spreadsheet is Read Only. Spreadsheets sent as email attachments and previewed within the email program are also Read Only.
The File property may be set to ‘Open as Read-only Recommended’ Another reason might be that the author (or previous user) had set the file to open as ‘read-only recommended’. When you open a file that has been given this setting, Excel prompts you to open the file in read-only mode, unless you want to make edits to it.
Another popular inquiry is “What does “read only” mean in Excel?”.
The chosen answer is it means you have disabled read-only in Excel file. 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.
How to edit Excel file in read only mode?
Now you have been able to edit excel file and make any changes to worksheet or workbook. 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.
1 Click File > Save As, and click Save button in pop-up Save As dialog. 2 Click OK to save excel file to replace the read-only one.
Why do my files open as read-only?
Less You may find that when you are opening files, they open as read-only. In some cases, this is for added security, such as when you are opening files from the internet, and other times, it can be due to a setting that can be changed. Here are some scenarios where a file opens read-only and some steps you can take to change that.