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…...referenced data changed, for dynamic array formula its spilled range...this operation(refreshing dynamic array formulas) itself also...