Excel volatile Spill Error

Occasional Visitor

How to resolve Excel volatile Spill Error in office 365 i.e. indeterminate behavior

1 Reply


As with any other error, correct the formulas or range to which they return result, such way that they work correctly with dynamic array Excel.


Simplest way could be to add Implicit intersection operator: @  in front of formula or range/array you use.