hi, i have been experiencing a few problems when trying to manipulate an excel template with a pivot table.
when i remove a column through worksheet.Cells.DeleteColumn(int) the pivot table’s data source range does not get updated to reflect the shifted columns.
when i rename a worksheet which is related to a pivot table the source for PivotCharts do not update, however PivotTables do. in the result file you will notice that the table’s values reflect the first tab, but the bar chart shows the values left over from the template and will not update.
i have attached a code sample with template and result that should demonstrate both of these issues. i am using cells v7.1.1.0