Automate

Hello Everyone,

I've created a new Excel template using Automate Studio to upload data to SAP. To make data entry more efficient, I manually added dropdown lists to the template using Excel's data validation feature. I tested the script, and everything works as expected.

However, each time I publish the Automate script to the Excel file, some dropdowns disappear. Has anyone experienced this issue or knows what might be causing it?

Kind regards,

Nick

Hello Nick

The only time I've had Excel formatting/formulas/etc not persist has been

• if I use a server-based product and do an autorun. 
• if I ran a Query script, although I can re-apply formulas as the Query writes to the Excel file

Are either of these use cases your scenario?  Please share details if not.

Best Regards,

Sigrid