PDA

View Full Version : Update Link



gnod
12-26-2007, 09:50 AM
Hi,

my officemate send me a ZIP file which contains different excel file under different folders.. when i open the Summary.xls it prompts "Do you want to update..?", when i click yes it prompts "File not found" but the other excel file which is link to Summary.xls are in the same ZIP file.. i already extract the ZIP file in 1 folder..
is it possible to update it automatically?

:help
thanks,

Bob Phillips
12-26-2007, 09:59 AM
It will be in a different directory.

Say no, when updating and repair the links.

gnod
12-26-2007, 10:04 AM
yes, the excel files are in different directory.. i attach a sample structure of the folder in ZIP file..

i forgot to mention, i use office 2000.. i can't see the repair link..


tks,

lucas
12-26-2007, 11:04 AM
Click on update and then on edit links
Then select "Change Source" and browse to the directory with the Data.xls

gnod
12-26-2007, 04:36 PM
is it possible to write a formula that will read the link in the Test Folder? something like ThisWorkbook.Path & "\..\"

because i'm avoiding the user to go to "Change Source"


thanks