paste link failing
 

Hi, Can any one help please, I have two work books and I link both using
copy-paste special and then paste link. But when I open them about an hour
latter the link no longer works.
Any one have any Ideas? Thank you in advance, Sam.