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
Bookmarks