Forum Discussion

runner200's avatar
runner200
Copper Contributor
Nov 28, 2020

excel spill error with row multiplication

I am having issues with excel when naming a row (row_name) to use in formula. Using the named row in a formula for cells below creates a spill error. When using the row_name to multiply I get a spill...
office 365
ExcelExciting's avatar
ExcelExciting
MVP
Nov 30, 2020

Hi runner200 

 

There is some data that is be obstruction show the result, or the cell is merged. 

 

#SPILL! error introduce in Excel with Dynamic Arrays (Microsoft365 [formally Office365] – mac/windows and Excel Online) with new calculation engine to handle the array functionality.

 

this blog post might be help for you to more in detail about spill

How to correct a #SPILL! error - Office Support (microsoft.com)

https://excelexciting.com/what-is-the-spill-error-and-how-to-fix-it/

 

when you are sending the file to your colleague the information is not getting spill because he/she don't have new calculation engine to handle the array functionality. 

 

if you are still facing the issue kindly request you to please attach the sample file.

 

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

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

Resources