UpdateRemoteReferences Property
True if Microsoft Excel updates remote references in for the workbook. Read/write Boolean.
Example
This example causes remote references to be updated in the active workbook.
ActiveWorkbook.UpdateRemoteReferences = True