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…...Cells Product Family cells-net aleksandr.l June 24, 2025, 2:16pm...calculations: 1 empty 2 empty 4 empty Cells with Spilled formula...