Each user's computer has to be set up to mount/map to the folder where the files are stored and in exactly the same way so that the file path entered in the container field is valid from the context of each such computer. If you have a mixed shop of both mac and windows systems, this will be a problem since file paths on Mac systems start with a volume name and start with a drive letter in windows.
I recommend that you not use "by reference" container fields. Replace them with container fields that use external storage so as to simply your references to these files. There are other ways to open a copy of these files on each server that do not use a double click, but which do work with external storage type containers.