Forum Discussion
yake-ho-foong
Jul 24, 2023Copper Contributor
Excel Office Script UDFs and What-If TABLE
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 S...
SergeiBaklan
Jul 24, 2023Diamond Contributor
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.