Working with connected excel file formulas

Question

I have two excel workbooks file_1.xlsm and file_2.xlsm. file_2 has multiple sheets and file_1 has two sheets : sheet1 and sheet2.

Sheet2 has tons of formulas that link to the data in sheet1 and the sheets in file2

The workflow when done manually, goes something like this: Sheet1 in file_1.xlsm gets populated with some data, all while file_2.xlsxm is open in the background so that sheet2's formulas can calculate properly.

I use Alteryx to populate sheet1 with some data but then how do I make sure that sheet2's formulas calculate properly since file_2 needs to be open in the background? Is there any feature within Alteryx that allows for this?

alexnajm · Answer

It should

vj28 · Answer

@alexnajm I currently use that method when I have formulas in one sheet that take data from another sheet in the same file. Will this work when formulas take data from a sheet in a completely different file?

alexnajm · Answer

No there is not a way to read in data from another sheet in Alteryx while it’s open - you can try to figure out some run command after you write out data to File 1 to open File 2 so it gets refreshed and then close it out

write to file 1 —> open file 2 to refresh —> continue with process