SaveLinkValues Property Example
This example causes Microsoft Excel to save external link values with the active workbook.
ActiveWorkbook.SaveLinkValues = True