Format is not preserved when I use the file path as a name.

[DKS0605974]

Whenever I write an output to dynamically name a new file with the Preserve Formatting on Overwrite selected (with specific range) the formatting is overwritten. Is there a way around this?

[alexnajm · Accepted solution]

Here's another example that I downloaded, tweaked a little, and it works fine! Solved: Excel output to formatted sheet - Alteryx Community

[DKS0605974]

Here is a screenshot of my work flow. The macro is creating a template before I write the file path to the output.

[alexnajm]

Apologies, I meant "seeing" as needing your workflow as an attachment, not as a screenshot. Either way, I provided another thread with a working solution, so perhaps it is best to take a look there and see where it may be different

Otherwise consider using Control Containers instead of the Block Until Done (if you are on 2023.1 or higher)

Good luck!

[caltang]

Try without AX80000, instead use AX only. 

in addition, the excel which you are overwriting to, try to keep to those columns - don’t have to declare the end row if it’s not needed. 

if it still doesn’t work, turn off AMP and try again.