How to Output multiple files on same Excel

[daniele_zatti]

Community - I'm trying to have multiple parallel processes output to the same excel file on different tabs. In order to let the cache flush each time it's written to, I put in a few "Block Until Done", but it's not working. Here is the flow. Any creative ideas other than setting up separate WFs and running one by one?

Thank you!
Daniele

[ed_hayter]

You could potentially use control containers if you are on a current enough version to sequence parts of the workflow so that writing to each sheet of the same excel file can be done

[daniele_zatti]

Thank you, yes, I have the latest version so I can use this feature. However not sure how I need to set up the containers to actually make it work. See below an example, I still get the error...

[DataNath · Accepted solution]

@daniele_zatti try setting up the Control Containers so that only the outputs are in them and staggered, like so:

[daniele_zatti]

Thank you both!