SOLVED
Filter turned on in Excel by default
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
JioLes
5 - Atom
‎05-11-2022
08:44 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
Labels:
- Labels:
- Optimization
- Settings
- Workflow
1 REPLY 1
rfoster7
11 - Bolide
‎05-11-2022
11:21 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
