The most common Microsoft Excel read-only problem is found in newer versions of the program. According to many users, this error occurs if you download an XLS or XLSX file from the Internet. But the reason can be many things: broken settings in the program itself, system errors, outdated versions of the program, viruses, etc.
On the Left, click ‘Protected View’. On the right side, uncheck the 3 options found there. Restart Excel and check to see if those files are still opening in ‘Read Only’ mode.
One of the next things we wondered was: 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.
Using Edit in Microsoft Office Excel, open document as Read-Only. Click on file directly and click check edit, Opens as Read-Only. Click the file in Read-only mode and check-out to edit, opens in Read-Only mode.
Why excel read only?
Excel sp readsheets 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.
Another common inquiry is “Why does my Excel file say read-only recommended?”.
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.
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.
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.
How to edit a file in read-only mode?
Click on file directly and click check edit, Opens as Read-Only. Click the file in Read-only mode and check-out to edit, opens in Read-Only mode. Scenario 2: Unable to check-in back documents.