If do not need the read only restrict password any more, follow the steps to remove it from Excel file. It is not on my programs list. I have also opened a document from local hard drive and that opens and resaves with no problems. Thank you for the information on how to attach images. Also try opening the file, saving as a new file, then have her try opening the new file on her pc, someone else's, and have someone try on hers to rule out a partially corrupt document. I have attached the file images to the previous communications.
Note: this feature does not encrypt your Excel file. If I start by opening a blank excel worksheet. The problem still persists though. Way 4: Forgot read only password Here will show you the way to remove the read only password in a few seconds without opening the Excel file. Now click on Owner tab in Advance Security Settings for User windows 6. This issue most commonly impacts Excel and Word in Version 1706 Build 8229. I'm hoping someone can find a solution to this; I have a similar issue files on SharePoint , and this is just a nuisance when you're 30+ files in.
If an author has to protect it from being modified by others but now you want to remove the read-only mode, read this page to learn based on the three cases. We do not use file redirection, and I made sure the users did not have the file open in the Preview Pane when the problem occurred. Also, try to open the copied Excel using the Open with. To keep changes, they have to save this workbook with a new name or in a different location. In addition, you may check on this for more information about adding and removing protection in your documents or workbook. The majority of our users did their daily reboots after awhile which cut down on this issue.
Double click on it and change the Value data: to 0 Close the Registty Editor. In this case, to disable read-only, do as follows. Step 3: In the Save As dialog, click Tools button and then select General Options. When I first started in this office. Josh Hi Josh, I have done a test in my SharePoint 2013 and i cannot reproduce your issue. In the meantime, please refer to this for workaround.
Locate the file or folder on which you want to take ownership in windows explorer 2. This tutorial will show you how to save excel as read only. I have an intermittent problem with Excel 2016. Subscribe Now: Watch More: Converting a read-only Excel file to an editable file will definitely be useful if you are collaborating with someone on a project. Click Protect Workbook in the same location and type password to unprotect workbook structure and windows.
Was it using a flash drive or through OneDrive? You can delete the old Excel file, and rename the new Excel file name to the old one. If it works fine every time. How to Grant Permissions in Windows 7 1. I apologize that I repeated my post, i just wanted to make sure I was being clear. To help you with this, we'd suggest removing the protection from your file. In two seconds, a dialog box pops up saying the read only password is removed. Thanks for all the replies.
We have Office 2010 standard. Unfortunately adding the site to trusted sites did not change the behavior. Step 2: Select the Review tab and click Unprotect Sheet. It is a piece of cake! What is the version of the excel? The file has been opened in read-only mode. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations. But if you want to disable excel file read only, removing or recovering excel file password to is necessary at first. Tips: Probably your excel file is also protected with open password now besides above edit restrictions.
Regular people still have problems and I really need help with this. Way 3: Excel file restricted with editing password When you wanting to open the Excel file that is restricted with modify password, you will be prompted to enter password for write access, or open the Excel file as read only. Then the read-only mode in the Excel 2016 workbook can be disabled. I click on the Excel icon to open the program 6. I am unsure what these means. When the user saves files to a shared network folder, and keeps them open on the computer, after a while they become Read Only, which forces the user to save them in a different name.