Linking merged cells gives #value error

[Granddad]

Hi to all again,
My worksheet has a group of cells merged and an auto sum function displays the answer in this merged cell.
When I try to link this merged cell to another workbook (using =) I get an #value error. If I link to a cell on the same page as the merged cell it works OK.
Any ideas how I might solve this.
Why merged cell? I want to keep a number sheets looking the same but the information is collected differently and merging allows me to have all sheets look the same.

Regards
J

[6StringJazzer]

I am able to do this with no error. Perhaps you have something else going on besides the merge. Please show the entire formula you are using. What cells are merged?

Ideally, could you simply attach both files, if they don't contain private information?