perhaps if you look into including indirect() in your hyperlink formula?