Forum Discussion
ayush4470
Nov 20, 2020Copper Contributor
Excel volatile Spill Error
How to resolve Excel volatile Spill Error in office 365 i.e. indeterminate behavior
SergeiBaklan
Nov 20, 2020Diamond Contributor
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.