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)
Thank you in advance for your help!