I have an addin with UDFs that my department uses, when opening a file with these functions in we have to relink it to our own copy of the addin. As this only takes a second I decided to write it into the addin however when the VBA relinks formulas to the addin it performs a full sheet recalculation which on sheets this size can take up to 10mins.

manualy fixing the links doesn't cause a full sheet recalc, why is the VBA version doing this and how do I stop it?