Output on different tab but same Excel Sheet

lenguyen1994

Hi Alteryx experts,

I am new to alteryx and have a question. I have 2 different workflows and would like the output to be on 2 different tabs but on the same Excel. I kept getting errors that "the process cannot access the file because it is being used by another process". May I ask how to solve this issue? Thank you!

PanPP

Hi @lenguyen1994,

I would recommend using a "Block Until Done" tool. This will stop Alteryx from trying to access both sheets at the same time. 

If you have more than three sheets, you can just chain as many "Block Until Done" tools as you need.

Hope this helps, if it does please like this post and if it helps resolve your problem, mark it as a solution. If you have any other questions, please let us know.