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

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"
wrote in message
...
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,
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
that and see if it improves. -- Regards,Tom Ogilvy"Bobbie
Jo"
wrote in message
...
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


.

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.

--
Regards,
Tom Ogilvy


Bobbie Jo wrote in message
...
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
that and see if it improves. -- Regards,Tom Ogilvy"Bobbie
Jo"
wrote in message
...
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


.