Excel file is locked for editing by me
User wants to have that Excel spreadsheet be password-protected, shared to his users with read-only permission & him be the only one who can edit it. I just had this problem and the MS knowledgebase article was no help (tell other users to close the document This is a shared Excel workbook, theyre supposed. I'm thinking that Office Apps are having a hard time syncing the changes made by the user because of the password that was set to the file. (Sometimes even if you DO close the original file properly, the lock file doesn't delete for some reason). Tried downloading a copy of the Excel spreadsheet, removed the password & have it uploaded back to OneDrive. If you don't close the original file properly that lock file still exists and won't let you open the file for editing until you delete it.
We've unsynced & resynced his OneDrive account & error still pops out. " resulting on him not able to edit the file. When he tries to open the password-protected Excel spreadsheet from the OneDrive (online) or OneDrive Desktop App, error pops out: "Error: Read-only: This workbook is locked for editing by another user.
#Excel file is locked for editing by me full
Inside that shared folder, there's an Excel spreadsheet which is password protect, also shared with other users (read-only permission) & the owner (user) of the Excel spreadsheet only has the Full Access to the file. User have a folder from OneDrive (online) shared with other users.