And you have to enter the password if you want to edit the file. In the image above, select a Folder where you want to save your Excel file. If you set a password to open the document the users will not be able to open the file without a password. I don't believe this read-only issue is related to a share restriction, as we have not changed the way everyone was accessing and did not have the problem. Whether you want other people to edit your excel workbook without permission? When we were making our Excel file read-only in our previous discussion, you had seen the General Options dialog box as the picture below.
I cannot open my Access databases. But when you save and open this workbook next time, you would find this workbook still recommend you to open it as read only. You do this by right-clicking on the directory or file and selecting Properties, then the Security tab. Tips: There is another way you could also protect workbook from editing. To open the file as just read-only, click on the Read Only option.
Just a quick update and answers to your questions. I just make a fresh installation of win and keep all my other drive partition as it is. Disabling Read-Only in the Excel file You will handle two types of read-only files. Office 2016 Office 2010 Office 2013 You may find that when you are opening files, they open as read-only. Can't save my changes because Microsoft has decided the file is suddenly Read Only.
Then others only can open this Excel workbook in a read-only state. In that case, you can make your file read-only with a password. So, your file is saved as Read-Only. Excel may present you with a message box which you may utilise. Step 3: In the Save As dialog, click Tools button and then select General Options. Usually, if you share an Excel spreadsheet with someone, that person is able to freely edit the spreadsheet.
You could use this option if you just want to view the file and don't want to make any changes. And its name is Read-Only. I read it differently from Kije. Also See: I now have 2 excel spreadsheets i work from everyday, adding to them both and making them available to other work colleagues. How to open a new copy of a Excel file? When I open the spreadsheet I am prompted for a password or I can select to Read Only.
I want to restrict my users from modifying the file. When you will open the file, you will get a dialog box like the following picture. But it forces them to resave with a new name. UserName What if you need a secure read-only option? You will find 4 options in the drop down. On File Explorer, right-click on OneDrive, and then select Properties. I have files I use all the time in my one drive folder, I'll open one and word decides it is Read Only and to make a change I need to save it as a new name. Why is my outcome different than yours? Step 4: This workbook has been marked as final and automatically saved.
This would be much better if it was similar to a protected sheet where an attempt to change a protectred cell would bring up a warning immediately. Then a message would prompt you that the settings would turn off typing, editing commands and proofing marks. You will have to decide for yourself how bad it would be if somebody were to crack your password or save over your file. Locate the file or folder on which you want to take ownership in windows explorer 2. I am just trying to narrow it down a bit. Say I have an Excel file.
In that way, the read-only file can be opened in editable mode by all. How to make a read-only template in Excel? Why does Microsoft shoot itself in the foot, and us in the back, like this? Otherwise, you just could open the workbook read only. Memorize the password or store it in a safe place, such as in a secure password manager program. Click on the Read Only button to open the file as read-only. Therefore, anybody who really, really wants to could get access to your document.
Everything seems to take 5 clicks now instead of 1 or 2 before. Set the file to read-only with a Macro By using a Macro, it is possible to set the file to read-only when the file is opened. Please, I beg you, test and confirm steps before posting solutions. So, I will apply a password in the Password to modify field. I checked the Properties and the Read-Only is not checked.