First post so go easy.
I have created template folder containing a source file which links to various destination workbooks saved in directories within the template folder.
Basically idea is that user would copy & rename template folder, then enter common data into source file with all destination workbooks updating accordingly.
This works fine with template setup, however once copied and renamed links are broken and all destination workbooks need to be redirected to new source file.
It is my understanding that links are relative, therefore destination files are able to locate source files provided directory structure remains intact regardless of changes to absolute location.
Any ideas? I am probably missing something obvious.
Bookmarks