Forum Discussion

Sjmry1's avatar
Sjmry1
Copper Contributor
Dec 13, 2021

Hyperlinks not updating after inserting rows

Hi there

I have a problem whereby when I insert rows into my Excel workbook my hyperlinks (all pointing within the same workbook but to different cells on different tabs).

I have found a way around this by using "Defined Names". However I have hundreds of hyperlinks so this will be extremely time consuming method to resolve.

Is there a more efficient way of having the hyperlinks?

Thanks in advance!

excel
    • Sjmry1's avatar
      Sjmry1
      Copper Contributor
      Dec 13, 2021
      Thanks for the reply but unfortunately I dont think that will help in my scenario when using hyperlinks within the same workbook. When I insert rows the cell position of some of the hyperlinks change and then when clicked on go to the wrong position. Is there a way to resolve that problem?
      Cheers
      • NikolinoDE's avatar
        NikolinoDE
        Gold Contributor
        Dec 14, 2021

        Sjmry1 

         

        =HYPERLINK(CELL("address",Sheet1!A1))

         

        CELL converts the referenced cell into a text, HYPERLINK evaluates this and jumps to it. And since are using a real cell reference, it changes with every change.

         

        An example file is included.

         

        I didn't do anything other than what I sent you before :).

         

        Hope this helps you to get further in Excel.

         

        I wish you much success with Excel.

         

        NikolinoDE

        I know I don't know anything (Socrates)

Resources