I am sure many folks have hit this and might put a wait in their flow or write a scheduled flow to cleanup later when the lock has expired.īut did you know that we can easily bypass this issue and delete this locked file? All we need to do is use the very versatile swiss army knife action known as “Send an HTTP request to SharePoint” to call the API that handles recycling of files. Select the Protect Workbook box and choose Encrypt. Getting to the file contents is straightforward enough using the Excel connector, but the really annoying thing is the file sharing lock the Excel connector then places on a file which typically results in an angry red dot of failure when using the SharePoint delete file action: The file is locked for shared use by. To learn the difference between protecting your Excel file, workbook, or a worksheet, see Protection and security in Excel. If the file won't open, rename the file in Windows. Reboot and try opening the file from within ExcelFile, Open. Get Ccleaner (free version) and delete all temporary files. Some things to try: Make sure that file preview is not active in Windows Explorer. I was recently working on a project where I needed to use Power Automate to upload an Excel file to SharePoint, crack it open to get to the goodies inside and then delete the file. Some people, especially those new to SharePoint, forget to do this one simple thing every after they make a change on a document. Excel Locked for Editing by Me SOLVED Excel Details: Re: Excel Locked for Editing by Me.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |