Linking player/team names results in #VALUE!

[Shamrock]

I am trying to link an overview sheet to my Bet Angel sheets. I have 40 sheets and just want to moniter the prices of the match odds in the tennis. I have loaded everything into the spreadsheet and created a new workbook which I want to link to the player, Back odds and lay odds. The back and lay odds are all fine but the player name returns #VALUE!
I suspect that this is because the source is a merged cell. Any ideas how I can get over this.

Cheers

[LinusP]

Its probably something like this

=Sheet2!C8:D8

Changing to..

=Sheet2!C8

Might fix it, assuming the cell is merged horizontally.

[Shamrock]

LinusP
It is B9:B10
If I copy it in the Bet Angel sheet to h2 it works fine. When I try to move it to a new blank worksheet which I have called overview I get the error, even if I copy it from H2.

[6thSense]

Try this:

Highlight the cell that returns '#value' and right click.

Go to 'Format cells' and select 'General' then 'OK'

Press 'F2' then the 'Enter' key on your keyboard.

[Shamrock]

No Change 6th

[Shamrock]

If Icopy the cell to H2 on the same sheet and then copy H2 to the overview sheet and do that then it works.
Cheers 6th