When I create a hyperlink, to a cell in a distant column, on the same row, it works perfectly. However, if I try to then Autofill it down a range of rows the Hyperlinks fail to link to the correct cell address.



The Hyperlink "text" displayed in each cell shows the correct destination cell address. However, the actual link address is identical to the very first cell used to create the Autofill.

In other words, if the Hyperlink in cell A1 points to destination cell AK1
and I autofill from that cell then cell A2...A40 all point to cell AK1. Even though the text displayed from cell A2...A40 has the correct incremented address, i.e. AK2......AK40
Here's the first hyperlink text: UTM Pipeline!AK6
Here's where the link takes me: UTM Pipeline!AK6

Here's the second hyperlink text: UTM Pipeline!AK7
Here's where the link takes me: UTM Pipeline!AK6

Hope this makes sense.

Hi Bushy,

I have had a similar problem recently, I had hyperlinks that were dynamically updated from an adjacent cell to take me to various places either on other workbooks or web URL's.

I found that if I tested the hyperlink on the first cell BEFORE i had autofilled it took me to the same URL as the first hyperlink everytime. My solution was to clear my IE cache and close the workbook (after deleting my hyperlink formula). Re-open my spreadsheet and re-do the formula this time autofilling before testing my hyperlink. It then worked a charm. Let me know if this works!

Thanks DB2