One of the biggest weaknesses of Excel is when you are linking to another cell in Excel using a hyperlink, { e.g. Ctrl k , Place in this document, Type the cell reference } you have to hardcode the cell reference. This obviously displaces it when I insert rows. Does anybody know how to create hyperlinks to other cells in Excel which update the same way normal cells do, i.e. when you insert rows the references change. Thanks
Bookmarks