Turn out after setting the base hyperlink, excel stops to convert URL to relative links. So this question can be closed.