The Excel links between 2 files are lost after sending them to a new PC.

[Dapante]

I have a spreed Sheet linked to another SS in a different Folder. In "My Computer" the linked Files work.... But If I send the ZIP (Folders and Files) to another computer the Folder Path Link gets Broken...

In my Origin The Formula says: =PROCV($D12;'C:\Users\user1\Documents\foldername1\example.xlsm'!$B$8:$N$77;10

The path between the workbook and the lookup workbook is not the same on both computer. When I copy the File to another PC it's a different "user" so it doesn't work. How can I link them? What should I do?

Onemore Info: THe Folder Tree is always the same in the folders:

File 1= C:\Users\user1\Documents\foldername1\all.xls (Gets Info from File 2, 3 and 4)

File 2=C:\Users\user1\Documents\foldername1\folder1\example1.xls

File 3=C:\Users\user1\Documents\foldername1\folder2\example2.xls

File 4=C:\Users\user1\Documents\foldername1\folder3\example3.xls


Thank you in advance for your help!

 

[Dapante]

The "Fix Path/Broken Link" is not a solution. I want something permanent!

 

[Fluff]

Cross posted The Excel links between 2 files are lost after sending them to a new PC. - OzGrid Free Excel/VBA Help Forum

While we do allow Cross-Posting on this site, we do ask that you please mention you are doing so and provide links in each of the threads pointing to the other thread (see rule 13 here along with the explanation: Forum Rules). This way, other members can see what has already been done in regards to a question, and do not waste time working on a question that may already be answered.