https://community.alteryx.com/t5/Alteryx-Server-Discussions/Prompting-Excel-Output-to-Refresh-All-Formulas/m-p/1256116#M15207 <P>I have a workflow that outputs my data to an excel file, completes the remaining formatting on a separate tab in excel via formulas, and then pulls the formula tab back into Alteryx to create PDFs and email out. I quickly realized that this process does not prompt excel to update all formulas in the workbook (yes, I verified that the workbook is set to calculate automatically). I found a <A href="https://knowledge.alteryx.com/index/s/article/Alteryx-Run-Command-Executing-Excel-Macros-VBA-1583461565312" target="_self">workaround using cscript</A> to open the file, calculate all formulas, save, and close...and it works beautifully on my desktop. However, it does not work through the server account when I schedule it to run every day of the week.</P><P>&nbsp;</P><P>I tried breaking the workflow into 2 with 1 outputting the data and another inputting the formula tab, but it still does not update formulas. At this point, the only solution I can think of is to keep the 2 workflows and schedule a PowerShell to run in-between them that opens and closes the excel file to update formulas. Any one have a solution that could work?</P> Thu, 28 Mar 2024 13:18:23 GMT cnolke 2024-03-28T13:18:23Z https://community.alteryx.com/t5/Alteryx-Server-Discussions/Prompting-Excel-Output-to-Refresh-All-Formulas/m-p/1256116#M15207 <P>I have a workflow that outputs my data to an excel file, completes the remaining formatting on a separate tab in excel via formulas, and then pulls the formula tab back into Alteryx to create PDFs and email out. I quickly realized that this process does not prompt excel to update all formulas in the workbook (yes, I verified that the workbook is set to calculate automatically). I found a <A href="https://knowledge.alteryx.com/index/s/article/Alteryx-Run-Command-Executing-Excel-Macros-VBA-1583461565312" target="_self">workaround using cscript</A> to open the file, calculate all formulas, save, and close...and it works beautifully on my desktop. However, it does not work through the server account when I schedule it to run every day of the week.</P><P>&nbsp;</P><P>I tried breaking the workflow into 2 with 1 outputting the data and another inputting the formula tab, but it still does not update formulas. At this point, the only solution I can think of is to keep the 2 workflows and schedule a PowerShell to run in-between them that opens and closes the excel file to update formulas. Any one have a solution that could work?</P> Thu, 28 Mar 2024 13:18:23 GMT https://community.alteryx.com/t5/Alteryx-Server-Discussions/Prompting-Excel-Output-to-Refresh-All-Formulas/m-p/1256116#M15207 cnolke 2024-03-28T13:18:23Z