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 have a pretty standard workflow to pull data, manipulate, email out the results and output the data to a .xlsm document, with macros to run certain tasks for the user.
When I run this using the desktop version of Alteryx (10.5) this runs fine without any issues.
However, when this is loaded onto our dev & cert servers (10.6) the data does not sucesfully overwrite the .xlsm file (as it's set up to do) so all the old data is there from when I ran it locally, although no errors are thrown on the server so the emails are still sent out (which contain the correct data). When I disable the macros and change the file type to .xlsx and load this back onto the servers this runs fine and the data is outputted as expected.
Is there a known issue with the Alteryx Dev/Cert servers not being able to output data to .xlsm, but has no problem outputting to .xlsx?
Did you ever resolve this issue? I'm hitting (almost?) exactly the same issue, except I'm using 2019.1 on both Designer and Server products.
My XLSM file has 3 worksheets, 2 of which are written correctly every day, but the third worksheet (which actually is the second one i.e. is internally referred to as Sheet2) will be blank 60-80% of the time. The Server shows me that the App completed successfully, and the output results shows that all records were written to the to file correctly. It's only when I open the file (or look at the file size) that I can see that the worksheet is still blank.
Should I reach out via email to resolve? I've tried all kinds of 'tricks' to fix the issue.