Writing to an Excel named range in the gallery

[BradBaker]

I have a workflow that writes to a file in Excel when run on my desktop.  There are three exports - two that export to tabs and one that exports to a named range.  When run via Gallery, it exports all three to new tabs and does not include any of the other tabs the workbook has.  I'm new to the Gallery, so I'm sure it's a settings problem.  Any hints?

[patrick_digan · Accepted solution]

@BradBaker I would start with this article: https://community.alteryx.com/t5/Alteryx-Server-Knowledge-Base/Assets-and-Packaging-Workflows/ta-p/4... My guess would be that you're packaging the output and would instead need to UNC the output (Under Options >> Workflow dependencies) and make sure the server has access to that location. You would also need to make sure you're not packaging the output when you save to the gallery.

[BradBaker]

Thanks @patrick_digan .  This looks like what we need.