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…...loaded (and not to store the data). Instead of calling “RefreshPivotTables()”...screenshot. Sequence of Refreshing Data Regarding your question about...