My workbook has the connected another workbook. I created the pivot table from that connection. When I try to get source from my pivot table (pivotTable.GetSource()), it returns NULL. How can I get source for pivot tables with external source?
I’ve attached sample document and demo project, that displays values of all properties in PivotTable object.