How to split data into different sheets of a single excel file at the same time?

[diabolic]

I just create a sample image as above to illustrate my question. As shown in the image, my data are split into 4 sheets (s1, s2, s3 and s4) and "Output Options" are all set to "Overwrite Sheet (Drop)". All outputs are contained by file Test.xlsx.

When I run the workflow, only s1 completed. Other 3 sheets are in error "

Error: Output Data (10): Unable to open file for write: ..\Test.xlsx Error Opening file: ..\Test.xlsx: The process cannot access the file because it is being used by another process. (32)".

However, if I only keep connect 2# and break other connections, then run the workflow. s2 can be done correctly. I can also do this on connect 3# and 4# separately, all of them are succeed.

Is there any way to produce my output sheets at the same time rather than run the workflow one by one?

[LordNeilLord · Accepted solution]

Hey @diabolic

You need to use the block until done tool here to avoid the overwrite errors:

[diabolic]

Thanks for the fast reply. It does work!

[gcf]

What is the formula used in the filter tool to get the data per sheet?