I hope someone can help or direct me towards help but I used a previous article to create a dynamic hyper link (I cannot post the link as I am too new, however, if you do a search on this forum for "Dynamic Hyperlink Formula" submitted by byundt you will see what I am referring to). This works like a charm, however, whenever I try to save the spreadsheet to a different drive the hyperlink still wants to look at the previous location. Is there anyway that the formula can be built to update the filepath when the document is saved in a new location? For further info the hyperlinks I am using are only pointing to sheets within the same workbook, I have no need to look outside of this workbook.

Thanks in advance,

Mark