Excel 2007 : Dynamic Hyperlink

Hi All,

I have setup some simple hyperlinks to cells on other sheets, but when I insert additional rows above the existing hyperlinked cell, the hyperlink keeps the original cell reference and no longer points to the cell I would like it to. Is there a simple way to be able to insert rows or columns and keep the hyperlink pointing in the right place.

Many thanks for your help.

Edit the hyperlink and check that the hyperlink regerence is not absoluted ($). If it is, try it with the $ removed