Excel Office Script UDFs and What-If TABLE

Copper Contributor

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.






1 Reply


I guess datatable is filled as entire range at once (actually that's VBA in behind), not cell by cell. If so you can't link OfficeScript to each cell calculation.