It will only give a warning, that a file is read-only, and shouldn’t be changed. However, this feature can’t stop a user from changing your file. Also read: How to Edit Document Properties in Excel ConclusionĪs you saw in the article, making an Excel file read-only, can help you to prevent unwanted changes to your file. If you open it again, you will be able to change it and save, without any restrictions or warnings. When you open a read-only file, you can see at the top of the file (next to the name) that the file is read-only.įinally, you saved your file without the read-only feature. If you select yes when opening a file (which means that you opened the file as read-only), you will have to save it as a new file after making any changes. This way, even if you make some changes and hit the save button, it will save it as a separate file. So if you only want to read the file (and it has been saved as read-only), it’s better to open it as read-only. One scenario where making the file read-only helps is when you don’t want yourself or any other user to make any changes in the file inadvertently. On the other side, the read-only option is just a notification for other users. So, if you want to be sure that your file is secured and not changed, you need to password protect it.
However, if a user doesn’t choose to open as read-only, the file can be changed normally. This option just notifies a user that you don’t want the original file to be changed. Cancel – if you choose to cancel, it will close the fileĪs you can conclude from the previous explanation, the read-only feature doesn’t actually protect your workbook.No – if you choose No, the file will open as a regular Excel file (not in read-only mode), and you’ll be able to make changes to the original file and save it.Yes – if you select Yes, the file will be opened in the read-only mode, which means that you will have to save it as new file (with a different name) in order to save your changes.Excel notifies you that the file you’re opening is read-only and asks you if you want to open it as read-only or not.
0 kommentar(er)
