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…...“RefreshPivotTables()”, it changes to multi select. filter_multiselect...by one. Problem 1: Filter Changes to Multi-Select The issue where...