Updating links to add-ins
It probably decides that a recalculation is in order after it has
changed a link; that will recalc the UDFs in appropriate circumstances.
I would suggest getting Workbook_Open to call the link-changing
procedure after the other workbook open actions have completed
Application.OnTime Now, "LinkChanger"
Sub LinkChanger() in a normal module does what Workbook_Open used to
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup