I am using formulas to link three workbooks on a network drive. I am finding
that I must have the two source files open in order for the links to update.
Manual update is unsuccessful as well. I am setting this up for other users
so I would like for them to be able to update the links without having to
open the source files. When I reproduce the links using files on my C drive,
it works perfectly. Any suggestions?

Thanks in advance!