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…...png 916×507 37.4 KB Problem 2 See...as expected. I can set the excel pivot table to refresh when...