This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
I'd use a Folder Browse tool instead of a File Browse tool. Then I'd use a text box to ask for a filename. Using ACTIONS, I'd update the directory and the filename and take control of the sheetnames in my workflow.
The gallery won't prompt this way.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.
Did you get any further info with regard to a fix for this bug? I'm still getting the same experience, where in the Gallery I'm always prompted to select a worksheet name when using an Action tool to load from an Excel file.
Found a few other community articles asking about this and seems like nothing will be fixed for a while, so I had to code into my action tool and tell my end user to just select any sheet. The formula I used is below
This issue has been identified as bug and has been submitted to engineering for review. Unfortunately there is currently no official date or version on when this will be fixed (DE19030). If this is a pressing issue to meet your business needs, I would recommend submitting a case with support for further review.