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

alteryx server Discussions

Find answers, ask questions, and share expertise about Alteryx Server.

Multiple Outputs to Excel Errors

Highlighted
Meteoroid

Hello,

 

I have a workflow set up to output ~30 tabs to one excel file. They all overwrite tabs and I have a ton of 'block until done' set up, but am still getting errors, which vary each time I run the data set. The error typically is 'the process cannot access the file because it is being used by another process. (32)". I have tried a bunch of different things but with no success. Even in the attached screenshot, I have a block until done before you outputs, and each output failed. Any suggestions? 

 

Thanks!

 
 
Quasar

Hi @mhart ,

You can try this  approach  without  block until .  Create sheet names  for all rows , union all the data   and use sheet name for 'change file/table name '  option is output  configuration.

sheet1.PNG