Similarly, there is no option in Excel to "disable #SPILL errors To fix a #SPILL error, you'll have to investigate and resolve the root cause of the problem Fix #1 clear the spill range This is the simplest case to resolve The formula should spill multiple values, but instead it returns #SPILL!How to fix it!Errors will not resurface Don't use an addin
Excel Formulas Not Working Possible Reasons And How To Fix It