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 formula in Excel that I am pulling into an Alteryx workflow (B). The formula in Excel pulls a date from another tab in the Excel file (notification that the data is current). Although the Excel file was refreshed (by another Alteryx workflow(A)) this morning (today is Monday), and the file date shows today's date, Alteryx workflow (B) is pulling in Friday values.
I can 'force' Alteryx to recognize the new data if I open the Excel file, make any change, (add bold, or a color), and re-save the file, not a sustainable solution. How can I make Alteryx recognize the updated Excel data?
Personally, the flow of Workflow A > Excel A > Excel B > Workflow B, doesn't make much sense. I would try and push your intermediate calculations in your Excel workbooks to Alteryx, thus preventing your data refresh error. Coming in and out of systems is something you should always try and avoid!
Of course Excel A might have a reporting layer, or contain data for other users, that's fine, it can still be kept as an output for workflow A, but you can still perform the intermediary calculations into Alteryx.
If you don't think this is a viable option then I would consider using the 'events' tab in Alteryx which allows you to trigger an external script which would simply open and close the xlsx file.
Thank you for your response. Workflow A takes a lot of resources and runs a long time, and is run on a scheduler to populate a shared departmental file. I go in 30 minutes or so later and do the final update which only takes a few seconds with Workflow B which is why we have two workflows.
It would appear that the root cause of the issue is Alteryx cannot read the Excel value of a formula* which points to other sheets. Up to this time I do not have any confirmation that there are issues reading 'hard-coded' values in Excel sheets (and I don't think this is true), but have confirmed the issue when trying to return the value of Excel formulas. I have included screenshots of what I experienced yesterday, showing file date times, and my laptop times.
Thank you for your suggestion, I'm sure it will prove useful for another situation I will encounter in the future. The issue at hand does not refer to writing back to the same Excel file, but to reading values from a formula in Excel.
My suggestion to refresh the Excel file externally was so that the File A being read already had the results from File B. Alternatively, move all of the calculations into Alteryx and read both A and B.
Alteryx ACE & Top Community Contributor
Chaos reigns within. Repent, reflect and reboot. Order shall return.