upadting question

  • Thread starter Thread starter Lost
  • Start date Start date
L

Lost

Is there a code/macro that will enable the user to update all the links to
external workbooks? To bypass the data tab updating and making the changes,
saving, closing,and reopening everytime u change the criteria for the
formula's. Hoping to be able to save then it will update then.
 
Try :
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks
ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks
HTH
Daniel
 
Ok I think I entered it in right but it gives me a compile error: Invalid
outside procedure.
 
I tested it with XL2003, XL2007. Which version do you own ?
Can you try :
ActiveWorkbook.UpdateLink ActiveWorkbook.LinkSources
or :
For Each lk In ActiveWorkbook.LinkSources
ActiveWorkbook.UpdateLink lk
Next lk
Daniel
 
Back
Top