Potential bug in excel. when adding rows, bookmark hyperlink is not updated with revised row number

Question

While adding new rows, the bookmark hyperlink with the same excel file doesn't auto-update the revised Row number. so for example -

/ created 2 sheets - (i) Index, and (ii) Invoices

/ On Index sheet - created hyperlink to invoice numbers on Invoices sheet.

/ when new rows are inserted on the Invoices sheet, subsequent row numbers are not updated on the links created on Index sheet.

Is this potential bug?

Thanks

Divyesh

Answer 1

Hi @Divyesh Bhatia, 

Thank you for posting your question in the Microsoft Q&A forum.       

Regarding when adding rows, bookmark hyperlink is not updated with revised row number.

For this situation please follow the step by step bellow 

For example I create 2 sheet "Index" and "Invoices" like you said:

Then I save the file. 

Navigate to the Invoices worksheet and enter data in cell A1. This is for demonstration purposes only; you may enter the data in any cell as needed.

Then I use this formular "=HYPERLINK(CELL("address",January!A1),"Go to January > A1")"  you could refer to this link : HYPERLINK function - Microsoft Support 

Paste the formular to sheet "Index", choose "Paste everything" 

 

Change "January" to "Invoices" 

It will link to cell A1 in sheet "Invoices". Then I will insert a row to sheet "Invoices" that will change the data to cell A2 

You will notice that the hyperlink formula automatically updates the row number to reflect the new cell location. 

So if you want the link to update the row number try to use the formular above 

Note: Worksheet names should contain text only. If the sheet name includes special characters (such as @, ;, (), numbers, *, &, etc.), the formula may not recognize the sheet correctly. 

Thank you again for your time and understanding. While my initial response may not resolve the issue immediately, I’d like to gather more details about your situation so I can assist you more effectively.          

I really appreciate your patience, and I’m here to help. Looking forward to your response.                  

---

If the answer is helpful, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".          

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread