Has anyone been able to get Office Script UDFs working in a What-if TABLE?
It seems that this does not work because when iterating through the TABLE function, Excel does not wait for any Office Script UDF to finish the calculations before moving on to the next iteration of TABLE. See attached screenshots of a simple illustration of a sample Office Script UDF (using Script Lab) in a TABLE. Any idea how to make this work correctly? Thank you.