This is a known problem with VBA UDFs. I have posted an article on how to fix this ages ago.
You can find the article here: https://jkp-ads.com/articles/fixlinks2udf.aspx