Linked files not updating

[Bobbie Jo]

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

 

[Tom Ogilvy]

if you aren't using a command like:

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink Name:=ActiveWorkbook.LinkSourcesthen try using
that and see if it improves. -- Regards,Tom Ogilvy"Bobbie Jo"

 

[Bobbie Jo]

Tom,
Thanks for the suggestion. I've just tried that, but
unfortunately, it did not solve my issue.

Any other suggestions would be greatly appreciated!!!
Thanks,
Bobbie Jo

-----Original Message-----
if you aren't using a command like:

This example updates all links in the active workbook.

ActiveWorkbook.UpdateLink

Name:=ActiveWorkbook.LinkSourcesthen try using

 

[Tom Ogilvy]

Sounds like you have some systemic problem. Perhaps you need to build some
test workbooks and with simple links and continue to mimic what you have
done until you encounter a problem.

Closed workbooks don't update links so perhaps you are updating in the wrong
order. Just a guess of course.