Forum Discussion
SPILL error message when using formula in merged cell
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. Th...
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