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…...zip (26.3 KB) Problem 1 In the source...settings for PivotTable. result.zip (22.7 KB) Workbook workbook =...