SPILL error message when using formula in merged cell

Copper Contributor

I want to "link" a merged cell with another merged cell on a separate page of the same workbook using the the = formula.  When I do it, it's giving me a SPILL error message about the merged cell.  The cell I am copying TO is merged with three cells, and the cell I am copying FROM is merged with three cells. 

 

Within my workbook I am using this formula successfully without error using merged cells.  So I don't understand why I can't do it now.

2 Replies

@julie50 

 

If you want to refer to merged cells, refer to the first of the cells, not to the merged range.

For example, if A1, B1 and C1 have been merged, use

 

=A1

 

and not

 

=A1:C1

@julie50 

Alternatively

=@A1:C1

works