Having just had another look i think this maybe what you need.

  ActiveWorkbook.UpdateRemoteReferences = True