Filter turned on in Excel by default

[JioLes]

Hi Alteryx community,

I'm trying to figure out if there's a way to turn on the Excel filters by default in one of my report using a Table Tool and a Render Tool. Every time I open the file, I need to click the "Filter" button in Excel. Is there any way to have that turned on by default? I can't seem to find an option in Alteryx.

Thank you for your time,

JioLes

[rfoster7 · Accepted solution]

My goto solution for this is to create a template excel tile, with the filters turned on, then, when I output data to it I use overwrite range and output to a specific range which means the column formatting and auto filters remain turned on. However I never use the render tool to output so I'm not sure that helps you any.