See attached sample: I call “Worksheet.RefreshPivotTables()”, which brings three problems:
AsposeCellsPivot.zip (26.3 KB)
Problem 1
In the source file, the filter for cell B6 is set to single select. After applying “R…...(filter, col width, localization) Aspose.Cells Product Family wknauf...with pivot table refresh in Aspose.Cells. Let’s address your concerns...