Problem with "Autofill" Hyperlinks

BushyIII

New Member
Joined
May 15, 2008
Messages
25
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

Hope this makes sense.
 

Some videos you may like

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
Guessing here, but are thre dollar signs in the first cell reference?

If so, delete them before autofilling.
 

BushyIII

New Member
Joined
May 15, 2008
Messages
25
No

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
 

Weaver

Well-known Member
Joined
Sep 10, 2008
Messages
5,196
The text you can see is simply the autofill incrementing the number at the end. As to how to get Excel to do what you want, I've drawn a blank, even whilxt trying to use the HYPERLINK function.
 

Watch MrExcel Video

Forum statistics

Threads
1,123,281
Messages
5,600,715
Members
414,401
Latest member
grenona2020

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top