CalculationOptions.LinkedDataSources

CalculationOptions.LinkedDataSources property

Specifies the data sources for external links used in formulas.

public Workbook[] LinkedDataSources { get; set; }

Remarks

Like UpdateLinkedDataSource, here you may specify data sources for external links used in formulas to be calculated, especially those used in INDIRECT function. For those external links used in INDIRECT function, they are not taken as part of the external links of the workbook and cannot be updated by UpdateLinkedDataSource. The match of those workbooks with external links is determined by FileName and DataSource. So please make sure FileName has been specified with the proper value(generally it should be same with corresponding DataSource) for every workbook so they can be linked as expected.

See Also