Getting error when I am copying the data to sheets in a xlsm workbook in parallel

mahi

I am trying to write the data for 15 sheets in a xlsm workbook parallelly, but I am getting "Unable to open file" for write error, I tried to use the Block until done/ join / crew macro for parallel write, but nothing works for me. Is there any suggestion on this  from anyone can be appreciated. Thank you In advance

PBUD.PNG

caltang

Because your outputs are competing for resources, therefore they clash. Even by adding BUD, it will not solve your issue since the sheets are separate in the workflow, so the source of which you are "blocking" with BUD is not doing anything significant. I do not recommend turning off AMP, but if you want to try that path - you can turn off AMP and run again, though I suspect you'll run into different errors thereafter.

Depending on your Alteryx version, if you are on v2023 onwards - you can try Control Containers to get what you desire without conflicting use of the same output file. This forces it to be sequentially written with AMP turned on as well.

If you're not on v2023 onwards, you can refer to my post here for some alternatives: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Multiple-input-files-into-a-single-output-file/m-p/1199176/highlight/true#M297470