The files might be named the same, but the links don't just reference a file,
they reference a particular cell on a specific sheet in that file, so if by
any chance the sheet names are so much as one character different then it
will error out on you. Could that be the problem at all?

Signature
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03
----------
It's easier to beg forgiveness than ask permission :-)
> I have an Excel database that is linked to about 400 workbooks that
> are contained in bout 35 different folders. The database and all of
[quoted text clipped - 15 lines]
>
> Crownman
Crownman - 24 Oct 2007 19:55 GMT
> The files might be named the same, but the links don't just reference a file,
> they reference a particular cell on a specific sheet in that file, so if by
[quoted text clipped - 30 lines]
>
> - Show quoted text -
Ken:
Thank you for your help. Since several people other than myself work
with a set of files that are supposed to remain identical to the
source link files it is certainly possible, that despite specific
instructions to the contrary, that some changes other than the actual
data may have been made. Since this will be almost impossible to
completely control, I'll have to figure out some other approach.
Again, I appreciate your help.
Crownman
Ken Wright - 30 Oct 2007 22:58 GMT
You're welcome - Best of luck with it, because CM control in Excel is not
the easiest thing in the world :-)
Regards
Ken...................
>> The files might be named the same, but the links don't just reference a
>> file,
[quoted text clipped - 45 lines]
>
> Crownman