Forum Discussion

Rebecca_Elle's avatar
Rebecca_Elle
Copper Contributor
Apr 01, 2020

Remove #SPILL! in Excel web version

Hi, I'm using the web version of Excel (365?) and I keep getting a #SPILL! error when I'm using the sum formula.  I've not had this when I used Excel last (back in Feb) I don't want this formula to s...
excel
Formulas and Functions
ExcelExciting's avatar
ExcelExciting
MVP
Apr 02, 2020

Hi Rebecca_Elle 

 

Your formula is having an array result and something might be obstructing to spill that information that the reason you are getting #SPILL! error. #SPILL! error introduce in Excel with new calculation to handle the array functionality the below screenshot might be helpful.

 

Example :

We wish to return the range of from A1:A10 in cell range of D5:D15, unfortunately I was having text "Blocking" which is obstructing the result to spill. When we remove the text "Blocking" it will spill the information.

 

 

How the spill error occur, video might be helpful : https://youtu.be/0dlpdQgI3QU?t=182

 

I have also attached the sample file, once you remove the text "Blocking" your result will appear.

 

 

Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert

If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more.

 

Resources