In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Filter turned on in Excel by default

JioLes
5 - Atom

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

1 REPLY 1
rfoster7
11 - Bolide

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. 

Labels
Top Solution Authors