Getting #VALUE! when linking spreadsheet

[Buddha1]

I am trying to link two spreadsheets. I have both open and the fields in both are formatted to currency. When I enter the = and then click on the cell I want to link to and hit enter I get the #VALUE! error. I can't figure out what I am doing wrong..... can anyone help??

 

[SkipVought]

B,

Does the cell you are referencing contain a formula that returns an error?

Skip,

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[Buddha1]

No,
The cell I am referencing contains a number that is hand keyed. It's really wierd I can't figure out why it won't work!

 

[Buddha1]

I figured it out the cell that I was trying to link to was merged so the link was trying to pull from a range.....
Thanks for you help skip.....

 

[bluedragon2]

ahhhh, merged cells takes another victim...


I can not stress enough how bad they are...

[Blue]Blue[/Blue] [Dragon]

If I wasn't Blue, I would just be a Dragon...