MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Why won't my hyperlinks update within the spreadsheet?

Posted by Bob Hoffman on June 27, 2001 7:01 AM

I have a spreadsheet that has several worksheets in it. On one worksheet I have a cross-section diagram with hyperlinks to another worksheet. The other worksheet shows the calculations that were used to determine the value of the clearance or interference of parts shown in the cross-section. The problem I'm having is that the worksheet where the calculations are being done is still undergoing some revisions and rows are being added and deleted to accomodate new calculations. When the new rows are added or deleted, the hyperlink from the cross-section does not follow the calculation on the other worksheet. Any ideas on how I can fix this?

Thanks in advance.

Bob Hoffman

Posted by Bob Hoffman on June 27, 2001 7:34 AM

Never mind, I found the solution!

It appears that if I name the cell first, and then link to the name, it will follow the cell when the cell is moved be adding/deleting rows to the worksheet.