Hello,
I am facing one an issue to persist "data links/sources" from ListObject to other Excel components like Charts or Pivot Tables.
Steps to reproduce.
1) Create Excel AddIn. 2) Add a ListObject to the worksheet runtime 3) Assign a Datatable to ListObject 4) ListObject populate data 5) User add Chart or PivotTable and use populated ListObject as "Data Source". 5) User save the Excel file 6) User re-open the Excel file 7) Recreate ListObject as VSTO obejct (Excel Add-In Dynamic Controls Sample - http://msdn.microsoft.com/en-us/library/cc442871.aspx) 8) Reassign refreshed Datatable to ListObject 9) ListObject populate data 10) Chart and/or Pivot table loose "Data Source" connection and show nothing..
How can I solve this issue ?
P.s. If I refresh data without closing and reopening Excel file everything works as expected.