Writing to Single File with Multiple Sheets no longer possible?

[PhilippS]

Hi all,

We have just received a new version of Alteryx Designer (Version: 2022.3.1.508 Patch: 4) and noticed a functionality that is no longer working: When trying to write several sheets to a single Excel file, the first sheet gets written and then the workflow results in an error saying that the second sheet cannot be written because the file is busy. For some reason it still works in applications, but not in normal workflows. Is this a known issue? Is there a workaround (other than making every workflow into an application)?

Error: Output Data (4): Unable to open file for write: Test3.xlsx - Can't open file: Test3.xlsx: The process cannot access the file because it is being used by another process. (32)

I'm writing to an existing file and both output tools have the 'Output Option = Overwrite Sheet or Range' selected. Example attached.

Thanks,

Philipp

[caltang · Accepted solution]

You can try turning off AMP for it to write multiple sheets. Reason for the error is because it's competing to the file simulatenously, therefore resulting in an error.

[caltang]

Some one posted here and you can refer to the comments too: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Block-Until-Done-tool/m-p/1208... 

[binuacs]

@PhilippS use the Block Until Done tool

[PhilippS]

Thank you!

[DanielG]

In my best Mandolorian voice, "Block Until Done is the way"  😁

[PhilippS]

Thank you, that works great for my example. But I think this wouldn't work if I had two different input tools? It only works if both outputs are written from the same dataset, so that I can put a "Block Until Done" tool into the workflow.