View Single Post
  #2   Report Post  
Old December 24th 09, 07:18 AM posted to microsoft.public.excel.links
Bill Manville Bill Manville is offline
external usenet poster
First recorded activity by ExcelBanter: Jul 2006
Posts: 473
Default 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

Workbook_Open does
Application.OnTime Now, "LinkChanger"
Sub LinkChanger() in a normal module does what Workbook_Open used to

Bill Manville
MVP - Microsoft Excel, Oxford, England
No email replies please - respond to newsgroup