This will trigger the notification in Word/Excel via Web Folders (perhaps on a different PC) that the file can now be edited.Ī My Docs Online Group Administrator, using the Desktop App, can also choose to Right-Click a file and “Force Unlock” from any location, which will also trigger the “available for edit” notification in Word/Excel. “The Desktop App has file lock(s) in place for the following files: (file-name).”Ĭhoose “Release” to free the lock. If you can re-launch the Desktop App from the same PC where the file was opened using “Lock & Open” you should see this message at login (remember to use the same My Docs Online Login ID): A single Excel file should be used by a single connection to prevent writing data from multiple connections and possible data inconsistency. Make sure your file is saved in the right format: for Excel spreadsheets use.
![onedrive excel file locked for editing onedrive excel file locked for editing](https://www.easeus.com/images/en/data-recovery/drw-pro/word-file-1.png)
There are only certain types of documents that support co-authoring.
#ONEDRIVE EXCEL FILE LOCKED FOR EDITING UPDATE#
If the file was Locked using the My Docs Online Desktop App and one of the above occurred or the Desktop App ended unexpectedly, the lock will need to be released via the Desktop App. An Excel file may be locked in OneDrive for an update or delete up to 12 minutes since the last use of the connector. If you are still getting the ‘locked’ error, see Excel file is locked out for editing. Reasons the Lock might still exist but be expired include the following that happened while the Word/Excel file was being edited from a Web Folders location: If the WebDAV “Lock” was placed on the file by Microsoft Office in combination with Web Folders, and it has in fact expired, this notification will usually come in about two minutes.
![onedrive excel file locked for editing onedrive excel file locked for editing](https://i.stack.imgur.com/RzsBr.png)
This will open a read-only copy and then later notify you that it is available for edit, allowing you to switch to an Edit session.
#ONEDRIVE EXCEL FILE LOCKED FOR EDITING PASSWORD#
Type a password into the text boxes provided if you want to do.
![onedrive excel file locked for editing onedrive excel file locked for editing](https://cdn.tgdd.vn/Files/2019/12/11/1226257/huong-dan-cach-dat-mat-khau-khoa-file-exel-don-gian-nhat--2020-11.jpg)
In the pop-up menu, you can provide a password to restrict changes to the sheet you’re locking, although this is optional. From the ribbon bar, select Review > Protect Sheet. When attempting to open a Word or Excel file via Web Folders, if you see a message telling you it is “locked for editing” by another user, and offering to either open a “read-only” copy or to “Notify” when the file is available for edit, choose “Notify” IF YOU ARE CONFIDENT the file is locked in error. To enable worksheet protection, open your Excel workbook and select the worksheet you want to restrict.