The file will be opened and you will not see the Read Only anymore. In December it became read-only don't know how and we have to do a file save as a new file. Open the password protected read-only file Now our file is made read-only using a password. Step 4: This workbook has been marked as final and automatically saved. Once that's done, you can manipulate and change the information.
Now select the cells you want to make them as read only here I select cells of range A1:C18. Save the Read-only file with Password In our previous steps, you have seen we have shown you how to make an Excel file read-only. We have an Excel spreadsheet on a shared drive that we update monthly some users have 2003, some have 2007, but this has not caused a problem in the past. Click on the Tools button and click General Options. When the file is opened, a message is displayed asking the user if they wish to open as read-only.
Click Review tab and Protect Sheet in Changes group. Now click on Owner tab in Advance Security Settings for User windows 6. Not unless you want features hampered and a broken workbook. It is a piece of cake! But I find Excel's interface in this area confusing. Step 2: Select the Review tab and click Unprotect Sheet. Whether you want other people to edit your excel workbook without permission? 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.
By this way you can make an workbook in excel 2010 read only and prevent users from making any changes to the file. Now in this article, I will list several possible cases that make your workbook and worksheet read only and introduce how we can do to remove read only status from Excel file. Once you have workbook open password or successfully remove open password, you would be able to do anything you want on excel workbook. It goes straight to Read Only and does not allow editing or saving. Enter a file name and click Save. But they still have choices to open workbook as read only or not.
I just want to make it so that I can't accidentally edit the sheet, and I don't want to have to deal with a password--not even a blank one. Try this: Assuming you are using SharePoint 2010, go to your document library's Settings, then click Advanced Settings. We provide tips, how to guide and also provide Excel solutions to your business problems. So if you're not a huge corporation which would want to have that functionality, it's probably not an option. When I go into File tab, it shows the permissions as anyone can change it.
It's not very robust and it's annoying to apply but quick to remove. I need for approx 20 users to be able to read-only a workbook but to allow only 2 users to make changes to the workbook. Case 4: Worksheet and Workbook structure is locked and read only 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. I want people to be able to open, look-at and print the documents but not change them. Locate the file or folder on which you want to take ownership in windows explorer 2. It means: to make the read-only file editable, the user s must have the password. To make your text legible in your spreadsheet, use to quickly adjust the text and size of the cell.
And then read only is disabled on this Excel file. When you click on the file to open it, Microsoft Excel dialog box will pop up with a message like the picture below: If you do not want to open the file as read-only, you will select the No button. Memorize the password or store it in a safe place, such as in a secure password manager program. But you also might not want them to change data, using it for review only. Why was doing this so incredibly easy in 2003 and so seemingly impossible, now, in the 2010 version? Step 5: When you are back to the Save As dialog, click Save to save this workbook. In two seconds, a dialog box pops up saying the read only password is removed.
Get out of the Excel program, closing the worksheet. Now you could also set a password to protect it, then only people who know the password could change your Excel Workbook structure. In a comment above, madamission pointed out that there's no password prompt to unprotect a sheet when the protecting password is blank, and that makes the approach more palatable. Take it easy, it is not the end of the world. I believe its the latter.
In essence, I want to do the same thing as setting the read-only bit for a file, but I want to do it for an Excel 2010 worksheet. Sometimes it doesn't work like that when working across a network. Groove is much cheaper, but will allow you the functionality of editing a file simultaneously in real-time. So remove read only in excel file. If the Excel is made to read only by Read-only Recommended or restrict with editing password, go and see the 4 ways to to make it editable. In the image above, select a Folder where you want to save your Excel file.
How to remove read only from excel file when it is marked as final? Thanks for contributing an answer to SharePoint Stack Exchange! Then while you open the Excel workbook next time, a dialog would always pops up and asks for a password for write access. When I open the spreadsheet I am prompted for a password or I can select to Read Only. Way 5: Protect sheets in Workbook to keep read only 1. At the top under the General tab will be a box checked if the worksheet is locked. Disabling Read-Only in the Excel file You will handle two types of read-only files. Double-click on the Excel file, enter password for write access. If your Excel sheet is locked with protected password, follow the 3 ways below to for editing.