Try :
ActiveWorkbook.UpdateLink , xlLinkTypeOLELinks
ActiveWorkbook.UpdateLink , xlLinkTypeExcelLinks
HTH
Daniel
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.