Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks fail when constructed using Autofil
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks fail when constructed using Autofil
Please refer http://www.mvps.org/dmcritchie/excel....htm#hyperlink
If this post helps click Yes -------------- Jacob Skaria "Bushy" wrote: 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hyperlinks fail when constructed using Autofil
Jacob Skaria wrote:
Please refer http://www.mvps.org/dmcritchie/excel....htm#hyperlink If this post helps click Yes -------------- Jacob Skaria "Bushy" wrote: 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. No, I cannot find any reference to using Autofill with Hyperlinks on the site. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 hyperlinks to Adobe files fail to open | Excel Discussion (Misc queries) | |||
hyperlinks fail after saving | Excel Discussion (Misc queries) | |||
Moving workbook to memory stick - hyperlinks fail | Excel Discussion (Misc queries) | |||
hyperlinks fail after saving | Excel Discussion (Misc queries) | |||
vlookup with table_array constructed from mid formula | Excel Worksheet Functions |