Linking not working

[Jack-P-Winner]

I have 4 books all linked to one master file where it gets its inputs from. # out of the 4 books are working fine. Since my lovely upgrade from Office 2010 32 bit to Office 2013 one of my books will not link. In the cells I am getting a VAULE####. I removed the VALUE#### and saved the book. Opened it back up and the cells were still blank so it did not even try to link.

Can anyone tell me what to look for or without the actual file uploaded its near impossible

 

[bobhc]

Good day Jack-P-Winner
Could it be because the links refered to relative and not absolute?

 

[Jack-P-Winner]

I will check when I get back this evening. Where would I look for that?

 

[kchiba]

Hi Jack,

By removing the VALUE, you may have deleted the formula.

There are a number of ways that can be used to link, so pleas send the files, the source and the target files, or better still just the relevant formula.

Cheers

Kanti

 

[Jack-P-Winner]

yes the formula was deleted. I put it back

 

[kchiba]

Sorry, just checking, please send the files, that is the best way to work.

Cheers
Kanti