Hi all,

I have a file which has some UDF's within it. Lately I've been trying to make this file "lighter" and went ahead creating an add-in containing much of its functionality. So I have copied the same UDF's in the aforementioned add-in (while keeping them in the original file as well for the test-phase).

After a couple of days during which I had no problems, the add-in seems to be troublesome. It has changed all the formulas from 
Please Login or Register  to view this content.
to 
Please Login or Register  to view this content.
The UDF's resulted in a #Value! or #Name! error afterwards - I had to replace the path with "" for the formulas to work again.

Can someone explain to me why this happened? Furthermore, why did this problem come up after days of normal operation? And lastly, how can I prevent this from happening again?

Thanks!