Output to multiple sheets within an Excel file not working

isaac_lane

Am having trouble outputting data to different tabs within the same excel spreadsheet, from the same alteryx workflow. Usually this is fine however adding an additional tab to the workflow update has caused the following error message:

Error: Output Data (215): Unable to open file for write: \\as-sydn-shrdat01\FILEPATH\FILENAME.xlsx: The process cannot access the file because it is being used by another process. (32)

And when I removed the additional work to be the same outputs as the previous version, the same error appeared. It's as if once the process error happened, it corrupted the whole workflow.

I have used multitudes of combinations of block until done, parallel block until done and label block until done tools with no success at all.

Have attached an example workflow for a basic theoretical understanding of what I am trying to do. Additionally the workflow uses the same excel file for inputs earlier in the workflow and this is done without any errors.

Thanks

Example workflow.yxmd

MarqueeCrew

@isaac_lane,

I leave nothing to chance.  I have replied with a workflow that will work for you.  The output of the first summary is held and submitted to writing and then the output records are counted and that count is appended (not really, just makes the next count wait) to the next summary output.  This pattern repeats.

Cheers,

Mark

Example workflow.yxmd