Eg. - I have 2 files - File A & File B
File A is created as the source file.
File B links to file A to get data.
File A then goes into file B and compares the data to ensure the link has worked and all is good.

I open File A - the source file
I then ope File B - the target file

When I say 'Enable Editing' on File B I get '#REF!' in File A for the check link back to File B.

How can I stop this? I have 50 files linking across each other and then check links to ensure that links have updated - It's these check links that fall over.

Thanks for your help.
Ydderk