This project has moved. For the latest updates, please go here.

hyperlink not updated when excel file changed location

Feb 6, 2011 at 3:25 AM

I have written data into the excel. There are hyperlinks which link to some external files. However, when I switch the excel file and its external filepath, the hyperlink in the excel doesn't update to reflect its current location.

I've tried opening the excel application itself to enter hyperlink and switching the filepath, the hyperlinks will get updated when i change path.

can someone help me.

 

Coordinator
Feb 7, 2011 at 6:52 PM

Hi,

Im not sure I understand what you do, but I guess you should use relative paths.

Check out how Excel saves the Uri's (save your workbook in Excel, extract it as descibed in the FAQ, under formulas,  and look at the hyperlink URI's)

Jan

Feb 10, 2011 at 2:26 AM

thanks for the response. I've figured it out myself.

I used the following:

ws.Cells[rowIterator, columnIterator].Formula ="=HYPERLINK("fileRelativePath","fileName")";