Hi,
We use Spill Formula, but it doesn’t recover after RefreshDynamicArrayFormulas and CalculateFormula
We have two sheets:
Sheet3 → Contains table Table1 it contains the data
Sheet4 → User function =@MY_FUNC(1) whic…...them anywhere repeatedly if performance is not a problem for you...