I am trying to upload a workflow whose first step is to run a macro to convert input files from.xls to .xlsx. However, I am getting the following error for each of the input xls files on the Alteryx Server:
"Tool #5: Record #1: Tool #1: Failed to run external program "C:\Program Files (x86)\Microsoft Office\root\Office16\excelcnv.exe": The system cannot find the file specified. (2) (Tool Id: 34)"
The xls files are all in the correct path, and this error does not occur when I run the workflow on Alteryx Designer.
Do note that I also added Office Access Database Engine 16.0.x64 for this workflow to run on Designer (if this will have an impact on the error of running on UAT)
Please help me troubleshoot.