Output data tool - issue to overwrite a worksheet

[Elena_B1]

Hello.

Could you please help with the message below? I'm trying to overwrite data in existing worksheet. 

Thank you

[grazitti_sapna · Accepted solution]

Hi @Elena_B1 , Please check the range mentioned in output tool and in the file you are overwriting to. Else you can share the file because in my case if I am overwriting a file not facing this issue. You can also try out with some other file and then troubleshoot the error by comparing both workflows. Also check if the file is being used or open in some other place.

[Elena_B1]

it is still not working. I have two output data to write into two worksheets in the same excel file. the first one works as expected and the second one gives the warning message.  

I tried to run the workflow separately for output 1 and output 2 by placing them in a separate container and disabling the flow for one output and running it for the second one. There were still no changes. 

Appreciate your help. Thx.

[Elena_B1]

I found the issue. The name of worksheet in excel does not match to the name of the output data.

"Alteryx Transaction Details$A1:AI10000" Alteryx  vs "Alteryx Transaction Details from GL" workbook.