Writing to Single File with Multiple Sheets no longer possible?

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

Example.yxmd

Error Message

Accepted answers

caltang

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.

All comments

caltang

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/1208010/highlight/true#M299810

binu_acs

@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.

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703