Encrypted Excel file - cannot open in Alteryx
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hello Community,
Can you help me figure out how I can use an encrypted excel file as an Output in Alteryx?
The content in the excel file (*xlsm) should be enabled and this is the reason I cannot see the details when I try to open it in Alteryx.
Thanks!
Margaritka
Solved! Go to Solution.
- Labels:
- Output
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey @mprodanova,
Is this a password protected Excel file in which case you can try my tool: Password Protected Excel Input Tool - Alteryx Community
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hey, IraWatt,
No, it is not protected with a password.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
It is not locked with a password. The file contains macros, so when you enable the content in Excel, the data loads.
Example:
Parent Product 1 = Fruits
Child Product 1.1 = Apple
Child Product 1.2 = Orange
etc.
So I guess my questions is - how to enable the macros/content in Alteryx?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Ah okay, theres quite a good thread on doing this here @mprodanova Solved: Run the excel macro using Alteryx - Alteryx Community they recommend this approach Triggering Excel Macros from the comfort of your Alteryx Workflow
