Suppose I have an EXCEL workbook with two spreadsheets. Call the sheets
SUMMARY and DETAIL.
In SUMMARY, cell A3, I have a hyperlink to cell A6 in DETAIL. So far, so good.
Now, however, out of necessity, I need to add a few rows to DETAIL, so A6 becomes A8. Now, my hyperlink does not work for me, since A6 now has different data.
Is there a way to protect my hyperlink against adding cells to the target spreadsheet (or to hyperlink in a different manner?)