The message at the top tells me I have to subscribe to office365 - I don't want office365, just to be able to use the excel files that I have been using for years. Step 5: Finally, press Ctrl + S to save the spreadsheet. This new system is, as Markus says, ridiculous. She has the Preview Pane turned on in Explorer. The files in question are on a Network Attached Storage Device if they makes any difference. In all of these cases, moving or saving the spreadsheet to a folder where you have full permissions will allow you to make changes.
Uncheck this to unlock it. Malicious users can edit the file and remove the password. When I open the spreadsheet I am prompted for a password or I can select to Read Only. I started this site as a technical guide for myself and it has grown into what I hope is a useful reference for all. Keep in mind that people may be able to copy data from the spreadsheet to another spreadsheet or file, and then edit it there if they wish to do so.
At the top under the General tab will be a box checked if the worksheet is locked. It is only when I try and access it from the shared folder from the other computer. So, I will not apply any password in the Password to open field. To create this article, 10 people, some anonymous, worked to edit and improve it over time. Usually, if you share an Excel spreadsheet with someone, that person is able to freely edit the spreadsheet. If the file is stored on OneDrive and your OneDrive storage space is full, you will be unable to save the document until you are under your allotted space. So, when you click on a read-only Excel file password protected to open it, Password dialog box will appear.
By using Protected View, you can read a file and see its contents while reducing the risks. However, if you forgot the read only password, how to get rid of read only in Excel file? All my data were on D drive. Let me know if you have any ideas. . I know it is kind of hard without being able to have it in front of you.
Ever since then I have had this problem only a couple of days. When an Excel file is made to read-only by marked as final, the data on this Excel file can't be edited. If you don't know how to do this, see step 1 below to begin. Now you could also set a password to protect it, then only people who know the password could change your Excel Workbook structure. It means: to make the read-only file editable, the user s must have the password. I need to make macro enabled workbook to be readonly for All except admin Also admin has a cmdbtn to click which asks for password, and if successful then file should be set to readwrite property. Information moves quickly with modern technology.
I've done a bit of research, and all I can find is that this is an issue with Office 2010 and no one seems to have a solution. This procedure will not remove protection in a protected file. One was created with 2007 read only-perfect and the latest with 2010 which i have to lock so nothing happens to it. Here are some scenarios where a file opens read-only and some steps you can take to change that. How the Excel file made to read only? Or click Review tab and select Protect Workbook option in Changes group.
I have tried changing the protected view in the trust center with no avail. The documents are on my laptop and I only work from a laptop, never a phone. I've had this issue in the past; backing the file up, deleting it, and restoring it seemed to fix the problem. To create this article, 10 people, some anonymous, worked to edit and improve it over time. The read only protection is on all my excel files.
Use Word Read Only Features Microsoft Word and other parts of Microsoft Office have similar tools to make files read only or otherwise restricted. Double-click on the Excel file, and enter the restrict editing password for write access. So, these are the ways to make an Excel file read-only and disable read-only from a read-only Excel file. The SetAttr has limitations, which the previous poster hadn't mentioned. There may be a few things better in 2010, but there are 10x as many items that have been made worse, or harder to use. Also I should add I have tried to open a word document from the shared folder and save that as well and I get the same error. If you have no idea about how to , following article would tell you several ways that you can use to restrict other people from changing your workbook.
I just make a fresh installation of win and keep all my other drive partition as it is. Locate the file or folder on which you want to take ownership in windows explorer 2. I cannot open my Access databases. Gives msgs such as querying if earlier version could be discarded? This does, however, prevent you from being able to change anything else. The remove protection in word document does not work either.