I have a workflow which formats data and writes it to an existing excel template. The excel file it writes to contains multiple sheets including a main sheet which contains a formula that references the sheet Alteryx is writing the data into. On Designer, I have the output tool setup (pictured) to "Overwrite Sheet (Drop)" with the sheet name referenced in the file path.
The workflow works fine when running it from Designer: it will overwrite the sheet reference in the Output tool each time while keeping the other sheets intact. My issue is when I publish the workflow on the Gallery and run it from there it will overwrite the entire excel file. Has anyone experienced this? It appears to be a bug with the Gallery because it works each time it is run on Designer.
Also note that the workflow includes an Interface tool which allows users to select a data file from their local device.
