Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / October 2007

Tip: Looking for answers? Try searching our database.

Help With Linked Files

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Crownman - 23 Oct 2007 22:20 GMT
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
the folders containing the linked files are contained in a single
folder.

I have received updates for several of the linked files and am trying
to replace some of the linked files with the updates (which are
exactly the same file name as the linked file).  When I do this and
open the database I get the error message that some of the files could
not be updated.  If I look at the edit links I get a list of nearly
every file in the database even if I have only tried to update a few
files.  I have tried doing the replacement via both copy and move with
the same result.

Can anyone give me some guidance on how to solve this problem?

Thanks you for your help.

Crownman
Ken Wright - 24 Oct 2007 14:19 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
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.