tmp files in above folder, search on your hard drive and whatever are found, delete them. Type "? application.StartupPath" without quotes and press enterģ. Same can be also be accessed through View > Immediate WindowĤ. If Immediate Window is not visible, type CTRL+G. Excel folder contains XLSTART folder in itself (In case, your XLSTART path is not in Appdata)ģ. Note - to find Excel path, you need to find XLSTART path. Now open the file and see if the problem disappears or not. Move those files to some other location (i.e create a backup of those files / folders and delete all files / folders from here). Please look into C:\Users\User_Name\AppData\Roaming\Microsoft\Excel (replace user name with your user name, you can directly reach here by copy and pasting following without quotes in Explorer address bar - "%appdata%\Microsoft\Excel\") and see if isĬontains few files / folders. By default, a data link is locked from editing to prevent undesired changes to the linked.
#MS EXCEL FILE LOCKED FOR EDITING BY ME OFFLINE#
One other possibility I am not able to confirm is that OneDrive for Business is somehow involved when storing the offline temproary file. Specifies the data in your Excel file to link to your drawing. What this tells me is that somehow the MS Teams application is also managing check outs. Once I had it open in Word, I went to "File > Info > Manage Document", cycled through Check out and Check In successfully. Use the option "Open in Word" and not "Open in Word Online" or "Open in SharePoint". The fix in my case was to confirm I was unable to make changes from within SharePoint and then go back to Teams. 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. As mentioned, I am in an working environment of SharePoint / Teams. To reiterate from before, I received messages that somehow the system thought I was personally responsible for the lock out and I was unable to control this file. I'll be watching this thread for solutions. I remember this sort of problem back in the days of SP 2003 and SharePoint Designer was a big help in those days, sure do wish we still had that. In some situations, you can use your mobile device to unlock the file and continue editing it. The file has been marked as Final and can no longer be updated.
An instance of the Office app is running in the background with the file already opened. The last time this occurred I solved it by saving the file under a new name, consequently I had to reset shortcuts for the six others who impute data onto the sheet. Excel will not allow me to open the sheet unless its in read-only mode. Oh, and I have tried resolving this in both Teams and SharePoint itself. The file might be locked because: The file is shared and another user is currently editing it. When I try and open it, it says that it is locked for editing by me when I know this is not the case.
The User in question is our previous network administrator. MS Teams is overlayed on SharePoint, the MS Upload Center has run a few times and the cache is clear. In the last few weeks I am getting users calling me telling me that an excel document that they are trying to access is locked for editing by a user who is no longer here and has not been here for about 2 years. I have resorted to downloading an offline copy to do my work.
#MS EXCEL FILE LOCKED FOR EDITING BY ME WINDOWS#
Start Windows Explorer and then browse to the folder that contains the document file that you tried to open. Microsoft excel says document is locked by me. Specifically there are two types of locks that can occur exclusive file lock and co-authoring file lock. The funny thing is the user that locked it is me! I cannot edit, save, delete or anything. File Format EXCEL (Microsoft Excel Open XML Spreadsheet) XLSX files are produced by the applications of Microsofts 2007 Office suite, namely by the product. 7 Ways To Fix Excel File Is Locked For Editing By Another User Issue. I now have a locked file (Word DOCX) that has remained locked for a few day.