Saving multiple output files as separate sheets in the same Excel workbook

[arundaka02]

Hi everyone

I have created a workflow which has 7 different outputs. Previously I have configured the Output tool to save 7 different Excel (.xlsx) files locally, but now I want to save them all into one Excel workbook, but for each output to be saved as separate sheets instead.

I've tried configuring the Output tool to select the same file and rename the sheet name but when I run the workflow I receive a message in the results window stating: "The process cannot access the file because it is being used by another process"

Can anyone help?

Many thanks

KA

[BrandonB · Accepted solution]

This should help! https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/How-to-write-to-multiple-tabs-separ...