sharepoint excel file access locked

when I write the result into excel file ( remote , office365) by knime server execute , will execute fail due to access locked, so how to fix this issue?

Hi @ycbing77

thanks for reaching out to KNIME :slight_smile: I just tried to reproduce your issue, could it be that you have the file open locally or in the browser while attempting to write your result into this file? You can’t write into the file when it is open somewhere else.

Best regards

Lars

Yes, I use office 365, the excel file save in One Drive, due to the result save to excel file , it i will pop up alarm “access locked” when someone open the execel file , I want to how to handle this issue .

I am afraid, I think there is not much you can do about this issue. You potentially could execute the workflow during a time in which the file is unlikely to be open or you could copy the original file and write into the copy of the file and distribute this file in some way to the end user.

Best regards
Lars

Hey @ycbing77,

haven’t heard back from you. Could you solve your problem in the meantime?

Best regards
Lars

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