O365 Excel: The resource you are attempting to access is locked

KNIME Analytics Platform
1

I am constantly getting this error lately and wonder if others are seeing the same thing. I use O365 and SharePoint exclusively as my working filesystem, and haven’t had issues like this for the last year.

I frequently create new files on SharePoint via KNIME, and then open them for review on my desktop. I close the file and then try to append/edit the file via KNIME, but the file is showing as locked in SharePoint. The only resolution is to hard delete the file on the SharePoint web interface (triggering “the file is is use by someone…are you sure you want to delete it?”).

I can’t tell who or what process has the file locked for editing…my local Office installation or KNIME somehow.

This is constantly happening to me and really slowing my work down. Is this happening to anyone else recently? I am using Knime desktop v4.4.4. Thanks!

2

I have 4.5.2 version and having the same problem. I don’t know but it seems a Sharepoint synchronization problem. Some times, when I open the new excel file it has the previous version.

3

Yes, I see the same old versions sometimes too.

It’s as though you have to safely get through the first manual open and close, then the file will work forever. But if something goes wrong on that first view, the file is ruined and I have to manually delete it.

4

I’m having the same problem, running with version 4.5.1.

Anyone have any insight or work-around?

5

I have narrowed it down to Excel Autosave and OneDrive/SharePoint Sync.

This is all after creating or updating an Excel file via KNIME directly on SPO.

If I explicitly hit Save in Excel and then let Excel handle the save and upload to SPO, everything works. If I close the file and assume that Autosave and Sync will handle it, it fails 90% of the time and locks the file.

We have a case open with MSFT to understand what’s happening here. It seems to be related to the May Windows 10 update, but don’t quote me on that.

6

Hi.

I have the same issue with 4.6.0 version.
It seems to me that sharepoint locks excel file for synchronization?
Some times when opening the file with excel it as the old version of the file.
Any solutions?

Regards
Hugo

7

This work is still ongoing. We have the OneDrive and the Windows team involved at this point but still don’t have a cause or resolution.

My workaround to disable Autosave is still working most of the time.

8

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.