Hello. I hope someone can help.

I have lots of Excel files on a shared network that are
linked together so that File1 pulls data from File2 which
pulls data from File3, etc. I use Vba to open each file
in series and update links every day. Unfortunately, the
files don't always update. I've found that sometimes the
linked file's path is represented by the letter drive I've
mapped to it (ie. P:\Marketing\DailyActivity\File1.xls)
and sometimes it's represented by the network address
(i.e. \\HQS400$\Shared\Marketing\DailyActivity\File1.xls )
even though, when I link them, I always use the letter
drive (which is the same letter used by my entire
department).

Often times the fileS do not update and there is no
consistency in how the path is represented that I can
attribute to the problem.

Any ideas on how I can force the files to update when I
open them would be greatly appreciated.

Thanks,
Bobbie Jo