srijansaxena
New Member
- Joined
- Feb 7, 2017
- Messages
- 1
Hi there
I have a link(ed) query... I am working with multiple excel linked files. the structure is something like:
Main Folder>> Sub- Folder + Loose Files
>>Sub- Folders>> Files
Files are linked within as well as between the sub- folders.
Problem: Whenever I copy the Main Folder to another system, the links stop working. the file path appears that of the old system, instead of the new system.
How do I rectify linking, so that system path is automatically updated upon copying to another system? since there are tens of links, manually updating each one is not really feasible.. Pls. help with this..
I have a link(ed) query... I am working with multiple excel linked files. the structure is something like:
Main Folder>> Sub- Folder + Loose Files
>>Sub- Folders>> Files
Files are linked within as well as between the sub- folders.
Problem: Whenever I copy the Main Folder to another system, the links stop working. the file path appears that of the old system, instead of the new system.
How do I rectify linking, so that system path is automatically updated upon copying to another system? since there are tens of links, manually updating each one is not really feasible.. Pls. help with this..
