Copper Contributor

I am building a tool to upload the data to Microsoft Sharepoint excel file. There are many users who can use the file at the same time, but it is critical for me to be able to upload the data to the particular worksheet in that specific file all the time. However it seems that when the file is used by other users I cannot do the updates to the file and I am getting this error: 

'{"error":{"code":"-2147018894, Microsoft.SharePoint.SPFileLockException","message":{"lang":"en-US","value":"The file XXX.xlsx is locked for shared use by email address removed for privacy reasons [membership]."}}}'

Is there a way for me to force an update to the file? To remove this Lock exception?

0 Replies