I have a set of folders containing workbooks with data validation between the files that works perfectly. The problem is when I move the folder to another computer, the links between the workbooks stops working. The 'refers to' in the names manager of the destination file has the location of where the source file was, not where it is now. How do I stop this happening please?