I am using the Output-Password-Protected-XLSX macro in my standard workflow to extract the data from Databricks and output it into password protected Excel file in a shared drive folder.
When I run my standard workflow locally, it runs fine and able to create password protected Excel output in the shared drive. No issue at all. However, when I run the workflow in the Alteryx Server it seems running forever and keeps looping. It seems to hang at the point after creating "..vNoPassword.xls" file in the shared drive. The workflow design is as per attached. And the workflow log when I cancelled it. The Alteryx server has connectivity to the shared drive and no issue running other workflows too.
Do we need to install MS office/Excel at Alteryx server so that this macro can run successfully?
Is there anyone who is able to run this macro in Alteryx Server? If so, could you please share the sample workflow which uses this macro? Really appreciate your help as we have requirement to create reports into password protected Excel.