Forum Discussion

Awfimohammed's avatar
Awfimohammed
Copper Contributor
Nov 30, 2020

SPILL! Error Merged Cells

Team,   I have a SPILL error on my spreadsheet while trying to equate merged array with another merged array from another sheet. Note that both arrays are same location same size, but when I I try ...
excel
Awfimohammed's avatar
Awfimohammed
Copper Contributor
Nov 30, 2020

ExcelExciting Please check the attached on original post, just added an example 

ExcelExciting's avatar
ExcelExciting
MVP
Dec 01, 2020

Hi Awfimohammed,

 

please check this link, were I have recently explained about the #SPILL! error, your case the error is appearing because the cells are merged. What you can do here in this scenario apply implicit intersection using the @ operator. That will resolve your issue 

 

=@'Sheet 1'!B4:D5

 

excel spill error with row multiplication - Microsoft Tech Community

 

Hope this might be helpful for you 

 

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.

  • Awfimohammed's avatar
    Awfimohammed
    Copper Contributor
    Dec 05, 2020

    ExcelExciting Thank you.

     

    It seems Excel added a new feature that caused this error on merged cells. Thanks for the tip, it works.

     

    My problem is that I want to distribute my workbook to many employees and I tried to find an easier way for them to make that calculation without getting SPILL! I finally used one cell instead of a merged to be safe. 

     

    Regards,

Resources