You won't be able to edit anything on this read only Excel file, unless you remove the read only from it. In this article Before you begin In order to complete this procedure, you must have at least two controls on your form template — one control that you want to disable or set as read-only and a second control whose value will determine the state of the first control. I tried the code below but it did not work. I have checked on the server and the file isn't open by anyone else but yet we still cannot edit unless we save as a new file. It could be one of your remote users that just doesnt realize they have it open? How do I make it so if person A has the document open while person B tries to open it, they get a message saying try again later? Once that's done, you can manipulate and change the information. I don't mind saving over the existing version once the changes are made, for example: 1. Excel will, by default, open documents in Protected View from potentially unsafe locations that includes SharePoint, but doesn't include local or network drives.
If you can unlock a file, can't your team unlock it as well? The reason is you probably don't have permission to read and write. If the specified conditions are true when a user fills out a form that is based on your form template, the conditional formatting is applied. I've checked all the check boxes for Read only and they aren't checked, not too sure where to go. If you figure it out before me post the answer! We had a problem with a script that left a stray process open and running causing use to not be able to open the file. It is a piece of cake! If you come back to find it doesn't work for you, please reply to us and unmark the answer. You'll want to uncheck the box that says Enable Protected View for files located in potentially unsafe locations.
Way 2: Excel file is in read-only recommended When you open a read-only recommended Excel file, you will be prompted to open this Excel file in read only mode, unless you need to make changes to this Excel file. Step 1: Open the Excel 2016 workbook. Can anyone help make it so it can open again and be edit thanks Hi Mark, There might be some conflict with Office cache, OneDrive and Office sync. Could you please provide the below information so that we can better assist you? At the top under the General tab will be a box checked if the worksheet is locked. Search for the named Excel worksheet in question. When the Excel file is made to read only by marked as final, typing, editing, commands, and proofing marks are disable and turn off. Turn it off and see what happens.
We tested the file last week and everything was working as it should so when a user had the file open Excel would notify us with the 'file is locked for editing by' message and so on. We have not enabled versioning in sharepoint and checkout is not required. Here is a screen cap of what you may see all my file names, and user names are blocked out along with my domain info, sorry buddy. If you have any feedback on our support, please contact. Please perform the following steps and check if there is any improvement: 1. In this case, to disable read-only, you need to unprotect the sheet by the following steps.
Unlocking Made Simple The key to unlock an Excel 2011 or 2016 worksheet is in the File menu of the Finder feature on your computer. Which Excel worked and what is on your desktop? It is just the excel files in one network share. Can other user edit the workbook on Excel application? I read the title and immediately thought this could be the issue, good catch Bryce. If forgot Excel sheet or workbook password, see for editing. With a single email, a colleague can share a complicated Excel worksheet for you to customize as needed. User A has full permissions to the file. If this is the case, you need to request permission from the original sender.
The setting you want is in Excel, not in SharePoint. Save as a dummy workbook e. And then read only is disabled on this Excel file. List of controls that can be disabled or set to read-only by using conditional formatting The following table lists the Office InfoPath 2007 controls that can be disabled or set to read-only by using conditional formatting and whether the controls are available for browser-compatible form templates. I read the title and immediately thought this could be the issue, good catch Bryce. User B wants to edit the same Excel file in SharePoint online site. Does the issue occur only to this specific workbook? Check the Trust Center Settings in the Excel options on a computer that is having this issue.
Clear the read-only status of a workbook Note: If your workbook is shared, anyone who has Write privileges can clear the read-only status. Have you tried to see if there is any stray excel processes running? On the bottom of Save As dialog, click on Tools, and select General Options. Close all applications and restart your computer. I have checked the shares on the server and there is no lock on them. Now, sometimes people need to open this workbook up to view the data inside. Step 3: In the Save As dialog, click the drop-down arrow next to the Tools button, and then select General Options.
If want to disable read only in Excel, enter password for write access. Your feedback is very important for us. 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. You may have to before you can post: click the register link above to proceed. Close and delete the original Assumptions. In the same tab you used to unlock the file, check the box to lock it. Customer wants to get rid of these messages.