Hello, I’m encountering an issue when publishing a workflow on Alteryx Server. My workflow performs calculations and then writes the results into an existing Excel template containing multiple sheets.
I use Control Containers (one per sheet) to write the data into each worksheet, and when running the workflow in Designer everything works correctly. However, once published on the server, I sometimes get an error indicating that the Excel file is being used by another program, even though the file is not open.
It seems that the server tries to write to the file at the same time without respecting the order of the Control Containers. I also tested using a Block Until Done, but the same issue persists.
Has anyone already encountered this behavior on Alteryx Server, and is there a solution or best practice to force sequential writing into the same multi-sheet Excel file on the server?
