community
cancel
Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Upgrade Alteryx Designer in 10 Steps

Debating whether or not to upgrade to the latest version of Alteryx Designer?

LEARN MORE

Bug: Multiple Output Data to Excel, Overwrite Sheet mode Error 1175

Alteryx Partner

If you build a workflow with multiple Output Data widgets, each going to the same excel file with different tabs, Alteryx will throw a Win32 level file-lock error.  This error appears to occur when using Overwrite Sheet (Drop) mode.  

 

This was observed in Alteryx Designer x64 ver. 10.6.6.17413

 

This error even occurs when using Block Until Done widgets, which appear to have an express purpose of not letting this happen, yet it does.  I have attached a short demo that reproduces the problem.

 

Error Screenshot.GIF

Alteryx Partner

Hi @bennes, I have tried it in Alteryx 11.3 and it seems to be working.

Capture.JPG

 

 

 

 

Alteryx
Alteryx

Hi @bennes

 

I've tested this in version 10.6.8.17850 and it runs without error for me. It errors if I have the Excel file open when I run the workflow since Excel locks the file. I also get the error if I try to run two instances of the workflow at the same time.

Alteryx Partner

Thanks, upgrading was my IT's support decision as well.  I was upgraded to version 11.3.2.29874 and I do not see the error anymore.  

 

Meteor

This appears to be very intermittent issue as for one of our workflows it ran fine most of the times but got the same error once. We refreshed the folders and re-ran to have a clean run.

Atom

I was having this issue too.  Changing my OUTPUT OPTIONS from OVERWRITE SHEET to OVERWRITE FILE fixed the problem for me.

Labels