Fear not, there is a fix for this problem. But co-authoring works, no problem. Now select the range of cells that you want to unlock and unhide. Select all of them by either clicking each once while pressing down Ctrl Control button , or pressing the first and then the last file while pressing down Shift. Remember, they can simply unprotect the workbook if they wanted to.
Now the picture is locked to cell. What are my options as a Global Admin? Please let me know if someone got exact solution of this issues. The solution I found was to Restore the locked out file to a previous version. Client side locks will occur if Office cannot negotiate a co-author lock falling back to an exclusive lock. Most of it can be removed or be heavily modified by any experienced Excel developer, though. It looks like there are different solutions or should I say workarounds for the same problem. I still plan to watch this thread.
After completion, reset the checks for the hidden attributes above. What can be done to correct how Excel reports who has the file open for editing? However another user did have it open. Select the file you want to change. Version2010 ; The protected Excel cells are given for the reference. Here, Microsoft Excel is only used to view the effect. Hopefully it works for you and anyone else with this issue.
Is the file server Windows, too? Select remove the following properties from this file. The impact is that other users have gon in and made changes after, so versioning is turned on which means the file has been overwritten. I have resorted to downloading an offline copy to do my work. This morning no one could edit the file due to multiple locks. I found that there is a document cache in the Upload Center. You should see a temporary file for the file in question, delete the temporary file. Store the file itself in a secure location on your computer like an encrypted hard drive.
I hope that helps someone. Hi Godwin Dinesh, Based on your description, I suggest you check the temporary files located in the same folder where the Excel file was stored. That should fix your issue. Then return and disable it. The wikiHow Tech Team also followed the article's instructions and validated that they work.
Additionally, in Excel for Windows, the Protect Workbook option in the Info menu also indicates that the workbook's structure is protected. Note: The domain login you are using on the computer you are performing this from may need to have proper permissions over the filer in order to do this. Thanks a lot for your reading. The files are not large, e. If you want to have a free trial of this utility, please go to first, and then go to apply the operation according above steps.
In litigation projects, digital forensic investigators try to establish multiple linkages in order to trace authorship. Now on to actually adding a password to an Excel file. I have noticed that it is reporting back who last made a change and saved the file, rather than whoever has the file locked open. The bug in Teams on locking files when doing online or in Teams editing is also a result from this not being properly integrated yet. When the file-save window appears, type in your file name, then select the Tools drop down menu. I am getting error message the file is locked by other user and can't delete it.
At this point, verify that nobody is accessing the file through shares and storage management or whatever way you choose. This worked for me as well. Yet when I try to access it for this exact purpose SharePoint won't let me. There is a command line program called Handle. Be patient, it could take a minute or two.
This article will show you how to add or change document author and document properties with following methods. I had assumed that Teams was a collaboration tool layered on to SharePoint and that somehow SharePoint would have ultimate control over the file pemissions. Hi, I followed your steps to protect the workbook: in Review tab, click Protect Workbook, enter the password, then check the Properties of the file in the Document Explorer, I could still see the properties like author, title, and I could edit them. Data security has become more and more important since the internet spreads the data more quickly than we can imagine. Part 1 Protect the whole Excel Workbook with the password. Write your passwords down and store them someplace safe.
I had a similar problem where Excel said that 'someone' was always in the file when they were not. I resolved it by right clicking on the file and selecting properties. Deleting that temporary file fixed it for me. If you want to open the file in Excel for Mac, ask the Windows-based author to adjust the password length. I have experienced the same issues other people have. Hopefully it works for you and anyone else with this issue. How To Password Protect An Excel File: Lock Cells and Formulas Easily Written by co-founder , Microsoft Office Specialist.