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.
@grsomer Within the output data tool, click on the dropdown and save as the proper file type. If you choose excel, you should be promoted to enter the sheet. Within the tool configuration, you can choose to overwrite the sheet.
2) No you will lose the formulas. What I've seen customers do is write to a different sheet using Alteryx. The formulas in another sheet will reference the written sheet and update accordingly.
Hi @DiganP Thank you for your help! The problem I run into is that when I am prompted to chose a sheet I enter the sheet name and a new sheet is created and appended to my workbook under the same name. This happens even when I select the option to overwrite the sheet.
I have one issue here. When I update the the template (i.e., update a "raw data" tab, which is linked to a formatted tab), if I don't open the file first, the file will have outdated information. I have to open the file first for the linked calculations to work. We have 80+ templates that are refreshed with a workflow, which are then sent uploaded to shared drive for user input. At the end of the week, we consolidate all files. If the user doesn't open the file (allowing the calculations to update) when we then perform our consolidation, the data in the master template is read in for each of the un-opened files