Encrypted Excel file - cannot open in Alteryx

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

Output

Accepted answers

Is this a password protected Excel file in which case you can try my tool: Password Protected Excel Input Tool - Alteryx Community

Hey, IraWatt,

No, it is not protected with a password.

How are you encrypting it @mprodanova ? I only know of encrypt with password.

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?