update vlookup directory

[YAN]

Hi, if you have a file that use vlookup to lookup from another file in one
directory, but then all the sudden the source file is transfer from one
director to the other, how can you master update all the file, please help..

 

[Alex]

In the file with the lookups. go to Edit --> Links
Select the sheet where your source file used to be and
click on change source.
You can now point to the appropriate file.
This will update all of the formulas that point to the
source file (unless you are using some complex "Indirect"
statements in which case you'll have to do a Search &
Replace on the Sheet name of the source file).

 

[YAN]

can I use Edit ==> Links to update the vlookup links (source file), if the
same file contain more than one source file. thanks