HYPERLINK TO MERGED CELLS
 

I am trying to hyperlink merged cells to another document into a single cell.
For some reason, the formula prints out in the cell, instead of the
information I want. When I go back to the document I am linking from, and I
go to the merged cell I am trying to hyperlink to the other document, the
indicator in the left hand corner is showing only one cell, instead of 2
cells, and the document I am linking to DOES show both cells in the formula
that is in the cell I have linked to..... How can I remedy this?