LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 30th 06, 01:51 AM posted to microsoft.public.excel.links
Posts: n/a
Default Updating external links

I want to create external links in a bunch of excel files (50-100) to one
central workbook with lookup tables. Is there any tricky way to make the
sheets search for the lookup table workbook (such as by name) in the event
the file structure changes, i.e. if the file are moved off the network onto a
cd. The lookup worksheet would always be kept in the directory with the log

I know you can go through and check the links in the menu in excel then
redirect the missing links to the workbook but would rather not have to do
this 50 to 100 times.

  #2   Report Post  
Old May 30th 06, 07:41 AM posted to microsoft.public.excel.links
Bill Manville
Posts: n/a
Default Updating external links

Good news! You don't have to do anything.

If the formula links are all to files in the same directory then Excel
will automatically correct them if the source and destination files are
all moved to a different directory.

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

Similar Threads
Thread Thread Starter Forum Replies Last Post
how do I improve performance when updating external links? Using formulas to enter NULL cell values Excel Discussion (Misc queries) 2 April 6th 06 02:48 PM
Problem with updating external links ChrisN Excel Discussion (Misc queries) 1 April 2nd 06 06:05 PM
Updating External Links DCSwearingen Excel Discussion (Misc queries) 1 January 25th 06 12:57 AM
External Links not updating Lou Di Pietro Excel Discussion (Misc queries) 0 September 15th 05 09:48 AM
Links updating? Kimmerz321 Excel Discussion (Misc queries) 3 September 1st 05 01:31 PM

All times are GMT +1. The time now is 02:03 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.

About Us

"It's about Microsoft Excel"


Copyright © 2017