I using an excel template with pivot table (crosstab report).
In this example, https://www.gemboxsoftware.com/spreadsheet/examples/c-sharp-vb-net-create-excel-pivot-tables/114, I can not find any methods to perform an action like refreshing data of pivot table (I used named range like data source). I'm looking for an feature can be support in this case.
Official response
Mario at GemBox
Hi,
This feature request has been implemented and is available in the latest versions of GemBox.Spreadsheet.
Regards,
Mario
I have same problem to refresh PivotTables already in an Excel file I'm feeding with data using GemBox. After finished to write new data I need to refresh PivotTables content.