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…...the data in the workbook(which may be used by some formulas so those...those formulas’ result may be changed too), those two methods...