Workbook.SaveLinkValues (Excel)
True if Microsoft Excel saves external link values with the workbook.
ActiveWorkbook.SaveLinkValues = True
True if Microsoft Excel saves external link values with the workbook.
ActiveWorkbook.SaveLinkValues = True