Nov 30 2020 12:12 AM - edited Nov 30 2020 12:48 AM
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 to do the calculation it gives SPILL error due to merged cells.
I send the spreadsheet to a friend, and it worked fine. Could that be something from my version or the settings I have?
Please assist.
Nov 30 2020 12:26 AM
Can you please attach the sample file, which will give us better idea to support 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.
Nov 30 2020 12:49 AM
@Faraz Shaikh Please check the attached on original post, just added an example
Nov 30 2020 02:02 AM
Nov 30 2020 09:25 AM
@Detlef Lewin Yes that works. How did it work on your side if you use same formula ='Sheet 1'!B4:D5, does is also give you a SPILL error? as I mentioned other people have no issue with that, only my PC?
Nov 30 2020 10:18 AM
Yes, I also get a #SPILL! error.
People who don't get a #SPILL! error are probably using older versions of Excel.
Dec 01 2020 04:22 AM - edited Dec 01 2020 04:30 AM
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.
Dec 04 2020 11:31 PM
@Faraz Shaikh 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,