View Single Post
  #3   Report Post  
Old January 5th 10, 06:46 PM posted to microsoft.public.excel.links
BigJimmer BigJimmer is offline
external usenet poster
First recorded activity by ExcelBanter: Aug 2009
Posts: 37
Default Updating links to add-ins

Thank you, that seems to have done the trick!!

"Bill Manville" wrote:

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