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 error that says that the spill range is too big. When I send it to a colleague it solves itself and the error goes away, what is going wrong? In the case below I have used the name "Inflation_factor_Mid_year_nominal" shown in the

 

 

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