Moving Links in Excel
I'm not a Mac user, so forgive me if this advice is inappropriate.
I would use the HYPERLINK worksheet function.
To link to cell Z3 on sheet Sheet2, with text "Product A":
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup